Question

Concatenate Two Fields t-sql

SQL Server, T-SQL, Concatenate

I need to concatenate two fields one varchar(50) and the other varchar(12)

The result I need is to see the full 50 characters of the first field even though all 50 may not be filled.

Thanks

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.

declare @v1 varchar(50)
 declare @v2 varchar(12)
 select @v1 = 'test', @v2='a'
 select cast(@v1 as CHAR(50)) + @v2