Re: Help. How to search for text with a CASE WHEN cmd?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Mar 2006 07:13:42 -0800
Message-ID: <1143731622.305506.134000@e56g2000cwe.googlegroups.com>

What you want is the instr command which will return the position of one string within another.

UT1 > @t3
UT1 > select
  2 case when
(instr('234234-Greg-325123616-1341436-234324-43-Don-235161436-2436-2346-435','Greg')
> 0) and

  3
(instr('234234-Greg-325123616-1341436-234324-43-Don-235161436-2436-2   4 346-435','Don') > 0) then 1

  5                       else 0

  6 end as TEST
  7 from sys.dual
  8 /

      TEST

---

         1

• now change Don to DXX and test again UT1 > @t3 UT1 > set echo on UT1 > select 2 case when (instr('234234-Greg-325123616-1341436-234324-43-Don-235161436-2436-2346-435','Greg')
  > 0) and
  3 (instr('234234-Greg-325123616-1341436-234324-43-DXX-235161436-2436-2 4 346-435','Don') > 0) then 1 5 else 0 6 end as TEST 7 from sys.dual 8 /

      TEST

---

         0

HTH -- Mark D Powell -- Received on Thu Mar 30 2006 - 09:13:42 CST