Scanning a Character Fieldgreenspun.com : 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 (email@example.com), May 21, 2004