SEO

#1 (**permalink**) 02-29-2008, 07:28 PM

hello all,

is there a quick way to convert a zipcode of type int, to a 5 character
char value ?
e.g.

declare @zip int
declare @czip char(5)
select @zip = 2109
select @czip = convert(char, @zip)
select @czip

but with @czip = 02109 instead of 2109 ?

thanks in advance

#2 (**permalink**) 02-29-2008, 07:28 PM

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/

#3 (**permalink**) 02-29-2008, 07:28 PM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

converting integer zipcodes to a 5 character char