Support 805.461.7300
Sales
NEW SITE. Our Technology. Your Success.

Mark Records that have a non-alphanumeric character in field

This command will mark records that include a character that's neither a letter nor a number

REPLACE X WITH "X" FOR LEN(ALLT(CHRTRAN(UPPER(first),[0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ],[])))>0

« Back to Commands

I wanted to drop you a line to tell you that working with Accuzip has been a breath of fresh air. I’ve been able to speak with a Live person each and every time I call. Your unlimited Tech Support, Personal Training and Price Lock Guarantee has given me the confidence that I made the right choice. Accuzip was able to solve my list issues and add value to my existing database at a more than reasonable price.
J.S., Newark, OH