Dave,
When I import the table form access I can not get the zeros to remain in
tact in the zipcode field no matter if I use char or varchar.
Do you know a solution I could look into?
Thanks,
Mike
_____
From: David Fafard [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 1:59 PM
To: CF-Talk
Subject: Re: Padding zeros in SQL Server
varchar... you can always cast in the future.
I use varchar for both zip and phone numbers.
dave
----- Original Message -----
From: Michael T. Tangorre
To: CF-Talk
Sent: Saturday, January 10, 2004 2:00 PM
Subject: SOT: Padding zeros in SQL Server
I am trying to determine the best way to store a zip code in a SQL Server
2K
DB. Some zip codes begin with one or more zeros, so what is the best way
to
store them? In access I make the field of type "Number" and set the Format
to 00000. Is there something equivalent in SQL Server?
Thanks,
Mike
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- SOT: Padding zeros in SQL Server Michael T. Tangorre
- Re: Padding zeros in SQL Server David Fafard
- RE: Padding zeros in SQL Server Michael T. Tangorre
- Re: Padding zeros in SQL Server Michael T. Tangorre
- Re: Padding zeros in SQL Server David Fafard
- RE: Padding zeros in SQL Server Michael T. Tangorre
- RE: Padding zeros in SQL Server Philip Arnold