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

We have been using the AccuZIP software for over seven years now. I believe that being an AccuZIP customer is one of the reasons for our success. Every time a question has arose, AccuZIP answered it completely and competently. When the post office did not have an answer for us AccuZIP did. If there was ever any conflicting info between the Post Office and AccuZIP, our AccuZIP customer service rep was always correct. We have experienced only excellent customer service. Let me make that clear not good customer service, excellent customer service.
C.M., Show Low, AZ