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

The main reason for this email is to let you know that Geoff is doing a tremendous job for you. He is fast, intelligent, funny, and a hard worker. We had a good time getting the little stuff taken care of and we are back 100% in one day!!!
K.W., Hobe Sound, FL