credit card # question

[ixxalnxxi]

often on sites, they do not display the whole credit card # in the 'account preferences' section lets say, rather the last 4 digits..... i am working on a site that will save the credit card # into the db.

is this done by extracting the last 4 digits when initially saving the credit card # and then just saving the 4 digits into its own field ?

thanks

[chazzy]

depends. some do it one way, some do it the other way.

before you agree to put credit card info in a database, you should read up on PCI compliance.

[yamaharuss]

What chazzy said!

And, hopefully, this is not MS Access db.

As for the formatting, you could do something as simple as

cardNum = "xxxxxxxx-" &Right(CCnum,4)