Hi all,
I have an Oracle db 9.2. There is a table CUSTOMER with a column called SURNAME. The database character set is WE8ISO8859P1. There are 35 million records in the CUSTOMER table a small minority of which have been entered including accented characters in the SURNAME field like ò for example.
I need to determine exactly how many rows contain accented characters and report on them. The majority of rows don't have accented characters. I need a query that will SELECT only those rows in which the SURNAME field contains some accented characters. In English the query to report these rows would be something like:
SELECT SURNAME FROM CUSTOMER WHERE SURNAME CONTAINS AT LEAST ONE ACCENTED CHARACTER;
or expressed differently as
SELECT SURNAME FROM CUSTOMER WHERE SURNAME CONTAINS AT LEAST ONE CHARACTER <a or > z and <A or > Z;
My string manipulation skills are not very strong and I would appreciate if anyone could help