Re: SQL Query - HELP!!!

dwarf8 wrote:
>
> 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

select *
from my_table t
where t.my_col like '%/_%' escape '/'

should work....works at least since version 7.3.x

--