> 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?
What you should remember is that some people end the Zip with the extra
digits, so you could have 00000-000, which means you can't store them as
Int
If you use Varchar then it'll be whatever length it wants
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
