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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Need to store 09 in SQL 7 Database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-23 : 20:08:53
Ron writes "Via a web form I have the person put in their Credit Card Expiration Month and Day. If the month and day are under 10 I have to store the information as 01 or 02... However, right now it only stores it as 1 or 2... The credit card number gets denied because it expects 01. How do I convert a 1 to a 01 and store this in the database?

Thanks

Ron"
   

- Advertisement -