Thread
:
converting integer zipcodes to a 5 character char
View Single Post
#
2
(
permalink
)
02-29-2008, 07:28 PM
SQL
Posts: n/a
Re: converting integer zipcodes to a 5 character char
Here is one way
declare @zip int
declare @czip char(5)
select @zip = 2109
select @czip = convert(char, RIGHT('00000' + CONVERT(VARCHAR,@zip),5))
select @czip
Denis the SQL Menace
http://sqlservercode.blogspot.com/
SQL