Adding Trailing Spaces

[mlr0911]

I have a query that I need to add trailing spaces to. I have a query that pulls the first and last name of our employees, but after the initial text, I need to add spaces up to 20. So the text of the first name plus spaces would be 20 characters and the last name in a different field would be last name plus spaces would add up to 20.

Thanks for your help.

 

[neileg]

Sounds like you're exporting fixed length data. You can use a fixed length output spec for your export that fixes this for you.