Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL Query - HELP!!!

SQL Query - HELP!!!

From: dwarf8 <dwarf8_at_ottawa.com>
Date: Fri, 11 May 2001 11:01:28 -0400
Message-ID: <3AFBFEC8.980A061A@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 Received on Fri May 11 2001 - 10:01:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US