I'm with Sergey, store the credit card info in a varbinary column.

-Mike

>I tnink you can use binary or varbinary data type to store such data.
>
>>I found the problem...
>>
>>It appears that the encryption control they are using to encrypt credit card numbers are putting characters that really screw with MSSQL - It's an ActiveX Control from Silicon Prairie Software. It made SQL Server think that the either the Index or the table was corrupted and wouldn't allow us to pull data from the one particular table. The reason we're not having the same problem with the other databases is because those credit card number are not encrypted. We're gonna have to un-encrypt the credit cards stored in SQL Server in order to avoid the problem, again.
>>
>>I appreciate all the help you always provide.
>>
>>Whenever we run into each other I'll have to buy you guys lunch.
>>
>>Thanks!