SQL trailing spaces removal to fit certain length

Asked Oct 19 '22 at 15:23

Active Oct 19 '22 at 15:38

Viewed 22 times

I have a SQL column of Employee City and the file output requires 40 characters in length. The system retrieves a value that is 58 characters.

This city value can change in length (Chicago, Warrenville), but will always need to be 40 characters in the end with spaces after the city value. I would like to use padding because trimming the spaces would be different each time.

edited Oct 19 '22 at 15:38

marc_s

732,580
175
1,330
1,459

asked Oct 19 '22 at 15:23

codestrerrr

1

and which database are you using and what have you tried so far? – nbk Oct 19 '22 at 15:27
what does "the system retrieves a value that is 58 characters" mean? – BryanOfEarth Oct 19 '22 at 15:28

SQL trailing spaces removal to fit certain length

0 Answers0