Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Query - HELP!!!
"dwarf8" <dwarf8_at_ottawa.com> ????? news:3AFBFEC8.980A061A_at_ottawa.com...
> I need to replace the underscore '_' character in my database with
> either dashes '-' or obliques '/', depending on each case.
> In order to determine which numbers get which replacement character, I
> need to find all occurances of numbers containing the underscore '_'
> character.
> Every time I write a script, I get stumped 'cause underscore '_' is a
> reserved character meaning "one character"...
> How do I either declare underscore '_' as a value or is there an
> "escape" as in old DB2 that will let me redefine the character for the
> purposes of this one script??
> Thanks all for great help!
> 8 out
Hi,
Oracle supports the escape clause. Use:
column_nae LIKE '%blabla\_blabla%' ESCAPE '\' Received on Fri May 11 2001 - 13:04:26 CDT