Re: SQL Query - HELP!!!

From: John Peterson <johnp_at_azstarnet.com>
Date: Fri, 11 May 2001 10:24:19 -0700
Message-ID: <tfo825cqnn4129@corp.supernews.com>

Dwarf,

You might look into using the INSTR in lieu of LIKE to do your pattern matching.

Hope this helps!

"dwarf8" <dwarf8_at_ottawa.com> wrote in message 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
>
Received on Fri May 11 2001 - 12:24:19 CDT