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]
