Mark Records that have a non-alphanumeric character in field
REPLACE X WITH "X" FOR LEN(ALLT(CHRTRAN(UPPER(first),[0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ],[])))>0 |
REPLACE X WITH "X" FOR LEN(ALLT(CHRTRAN(UPPER(first),[0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ],[])))>0 |
K.W., Hobe Sound, FLWe love the database and how simple it is for us to make simple codes as our business always has since 1955...We are grateful to you and your staff that take client service so seriously.