white spaces

[Norman55]

im hoping someone can help....
instead of trying to get rid of whitespace i need to created them so when i return the results in a Qry if there are only 2 charactors it will force 2 white spaces at the end ?

 

[RiverGuy]

SELECT CONVERT(CHAR(4), YourColumn)
FROM YourTable

The CHAR datatype is fixed width. So if you convert your column to CHAR(4) in your query, all values for that column in the resultset will have a length of 4.

 

[Norman55]

thanks