Scanning a Character Field : LUSENET : DBAzine : One Thread

Hello, I have a customer name field in an ORACLE 8i database, which contains some customers with European characters in their names, such as an German umlaut. I want to retrieve those records that have these kinds of characters. I thought there might be a function or combination of functions that I could use, to search for any ascii character > 90 in a string, but I haven't been successful. Searching for *a* character, I can do using instr() and chr(), but not for "greater than".

Thanks in advance, Tom Hauge Eddie Bauer

-- Thomas Hauge (, May 21, 2004

Moderation questions? read the FAQ