Support 805.461.7300
Sales
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

All of you at Accuzip are TOP NOTCH in customer service! I've been mailing for 25 years and I only wish I'd found Accuzip years ago! You are all wonderful. Thanks for being there for me!
L.B., Englewood, FL