You can CAST the first value into a CHAR field which will pad the value with spaces then put the second value on the end. Here’s an example.
<pre>declare @v1 varchar(50)
declare @v2 varchar(12)
select @v1 = ‘test’, @v2=’a’
select cast(@v1 as CHAR(50)) + @v2</pre>