Posted by hharry on 10/02/29 11:48

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

• Next in forum: Re: converting integer zipcodes to a 5 character char
• Prev in forum: Re: Convert Access Query to SQL Server View
• Thread view: converting integer zipcodes to a 5 character char

[Reply to this message]