6 Nov
2012
6 Nov
'12
7:23 p.m.
Try a last line such as
WHERE NOT HEX(pname) REGEXP '^([0-7][0-9A-F])*$' or WHERE pname REGEXP '[^ -~]'
Thank you, Paul. Getting much closer now. It does retrieve a number of valid accented characters, but since the number of affected records is probably in the low 100's, it won't be difficult to visually scan the results. There might still be some records missed, so will do some testing & see where we stand. Many thanks again! Cab Vinton Sanbornton PL