Posted by Alexander Kuznetsov on 10/02/56 11:48

select substring(convert(char,100000+123),2,5)
select substring(convert(char,100000+1234),2,5)
select substring(convert(char,100000+12345),2,5)


-----
00123

(1 row(s) affected)


-----
01234

(1 row(s) affected)


-----
12345

(1 row(s) affected)

• Next in forum: Question on Transaction Log Backups
• Prev in forum: Re: converting integer zipcodes to a 5 character char
• Thread view: Re: converting integer zipcodes to a 5 character char

[Reply to this message]