How to add characters exactly 25

[ddtpmyra]

Here's my case...
I need to allocate exact 25 characters on a field. For instance the name is Lucy this means I have to add 21 extra spaces at the end.

How can I do that on my select statement?

 select name,25-LEN(name) as difference,
 case when 
 25-LEN(name)<25 
 then 
 ??????????
 else 
 ???????? end len
 from person

[ddtpmyra]

I thought of this…

Adding 25 blank space at the end of the last_name and only select the 25 char from the left.

Select UPPER(LEFT(name+'                         ',25))
 

[ddtpmyra]

OR....

Select UPPER(LEFT(name+space(25),25))

[Rabbit]

Or

[name] + SPACE(25-LEN([name]))

[ck9663]

If the field "name" is a character and not a varchar, you might want to trim it first before adding any space.

Happy Coding!!!


~~ CK