I need to right pad a sql Server field with spaces. I have tried:
Select Field + replicate(char(32), 10)
Select Field + space(10)
Select Cast(Field AS CHAR) + replicate(char(32), 10)
The field is NVARCHAR(50)
I can right pad with any character BUT space.
I tried ANSI_PADDING both OFF and ON