>>>>Yes, that would work.
>>>
>>>Thanks. Although it would be a lot better to come up with a list of LEGAL characters. The illegal one will turn out to be rather long. Thanks again.
>>
>>In this case you can do double chrtran. I used this technique a lot when I knew allowed characters.
>I'm sorry. What's a 'double chrtran'?

lcBadField = 'abc%^#$12aac'

lcGoodChars = 'abc'

*lcFixedField = CHRTRAN(CHRTRAN(lcBadField, lcGoodChars, ''), lcBadField,'')


lcBadChars = CHRTRAN(lcBadField, lcGoodChars, '')
lcFixedField = CHRTRAN(lcBadField, lcBadChars, REPLICATE('*', LEN(lcBadChars)))
=MESSAGEBOX(lcFixedField)