Finding records with illegal characters

[WarrenN]

Not sure if this should go here or in DDS, but I'm trying to find all records in a table that include illegal characters in any of their fields. There are a little over 1 million records in this table, so hand checking all of them isn't very practical. Does anyone know of a way to detect all illegal characters in a table? Please respond if you need more information.

Thanks

[WarrenN]

Re: Finding records with illegal characters

Ended up just using a SQL query comparing string fields with the 'LIKE' function to find certain hex values. Won't find all illegal characters, but I think I found most of what I was looking for.

[GLS400]

Re: Finding records with illegal characters

Hi WarrenN:

See if this can help:

http://www.code400.com/forum/showthread.php/6527-Hex-Characters-from-Data-Entry

Illegal characters probably have a value less than x'40'

Best of luck
GLS