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

You guys have indeed been great partners in aiding us with getting our mailings processed through your software and out the door.  I want to say we’ve been with you guys for at least 12 years now, if not longer.  Find something good you stick with it is how I see it.
P.H., Colorado Springs, CO