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

I do want to say that I deal with MANY software tech support departments, and yours is second to none, they never fail to resolve an issue and are always kind and courteous, that is sadly rare.
D.W., Fort Wayne, IN