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 |
M.D., Paradise, CAI can't tell you how much I appreciate the awesome tech support you guys give. I am NEVER going back to postal soft... you guys have spoiled me.