Padding character variables with zeros or spaces in SQL Server

[sivi]

I would be grateful if someone could advice me on padding character variavbles with zeros or spaces in SQL Server

Many Thanks

 

[mwolf00]

USE pubs

GO

SELECT RTRIM(au_lname) + ',' + SPACE(2) + LTRIM(au_fname)

FROM authors

ORDER BY au_lname, au_fname

GO


Also check the REPLICATE function...
REPLICATE(character_expression, integer_expression) ---------------------------------------
HAPPY THANKSGIVING!!!!
mikewolf@tst-us.com

 

[sivi]

Mike

Thanks,

I need to pad to a required length and this length is variable. Depends on how many characters out of 15 (field length) are populated on the table, the rest must be padded with '0' or spaces on extracting this data from the table.

Cheers
Sivi

 

[SQLSister]

USe len to find out the len of th string and then replicate to get a string with the right number of 0 or spaces and then concatenate the field with the resuilts of replicate.

 

[tlbroadbent]

See my reply in thread183-415882. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.