>>>>>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)
>
Thanks!