Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rivaldo
Starting Member
7 Posts |
 Posted - 2002-05-30 : 16:28:12
|
| We have an application that pulls data from sql 7. We let the users update the database from our intranet, we are having problems when they want to put a zero infront of the fields, it is necessary for some account numbers, once they put the account number with a leading zero and hit update the account number is included in the database, but without the leading zero. I've tried all the datatypes that would apply. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-05-30 : 17:34:57
|
| You need to use character data types to persist leading zeroes.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
Data Type