Try the import wizard ( found on the toolbar ) to import the data
from access. I don't have SQL Server in front of me but I believe
there should be an option to 'transform' on import.
Dave
----- Original Message -----
From: Michael T. Tangorre
To: CF-Talk
Sent: Saturday, January 10, 2004 2:18 PM
Subject: RE: Padding zeros in SQL Server
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]
