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

"You should know and I have told this to many of the people I have spoken to on the phone over the years. All of your employees are always super helpful, knowledgeable and professional every time I need to call in. I always have my questions answered or my issue resolved. Thanks to you and your staff!"
A.B., Long Island City, NY