According to Mastercard, Visa and American Express, the CVV information is not supposed to be stored anywhere. We are in process of getting compliant with these security measures, and I need to know if there's a shortcut to searching that field to see if it's anything other than blank. I tried >= and it complains I don't have priveledges to edit the field. It does accept == though, and I can see that I have about 65 accounts out of 1900+ with information in that field. Amex also lists a requirement to never store magnetic stripe data either, and in one account I noticed the "Extra Info" button by the CC stuff has a swipe data field, you may need to do somethign with that too. I don't have a swiper, so I know there's nothing in there in my database. Thanks, Chuck
Search for blank (with just an equal sign), then go to Scripts and do a "Find Omitted" to reverse your found set. You can also use the Replace function to simply replace all customers with a blank value.