you are using to enter the values?
_____
From: Stan Winchester [mailto:[EMAIL PROTECTED]
Sent: 01 October 2004 22:58
To: CF-Talk
Subject: SQL Server dropping zeros
I had the strangest thing; I've got a varchar field in a SQL Server 2000
table that stores zip codes. When we import the zip codes leading and
trailing zeros drop off when inserted, for example: 07080 will become 708. I
thought what if I increased the field length from 10 to 12 (for zip-4), and
for the insert I could add a leading and trailing space like this ' 07080 ',
and guess what? The zeros did not get dropped. I thought what a stupid fix!
What have others done to get around Microsoft telling me I don't need the
zeros?
Thanks, Stan
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
