RE: to_char – SQLServerCentral

Lowell

SSC Guru

Points: 323504

August 20, 2009 at 9:21 am

#1042202

ok, i think you want to left pad the string so it is right aligned, correct?

two ways I can think of, using either the SPACE or REPLICATE functions, and grabbing the RIGHT of the string.

insert into test1

select RIGHT(SPACE(19) + '456',19) UNION ALL

select RIGHT(replicate(' ',19) + '876842',19)

insert into test1

select RIGHT(replicate(' ',19) + YourColumnName,19) From YourTable

replicate is handy if you need preceeding zeros instead of spaces

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!