SOT: Padding zeros in SQL Server

[Michael T. Tangorre]

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]

---