Look for a value inside an string

[Raul2005]

I need some help to:

ID USERNAME MESSage
1 nrj hello(nrj)there is a..
2 pqt hola(nrj) today we had
3 nrj Try one more(nrj)time


I need the following resul

ID USERNAME MESSage STATUS
1 nrj hello(nrj)there SENT
2 pqt hola(nrj) today we RECEIVED
3 nrj Try one more(nrj) SENT

As you can see I need to look inside the message string for the value I have in field USERNAME Ineed to compare and if inside the message string I found a value like the USERNAME I need to display another field with tthe status set to SENT in other case it will be se to Received.

I will appreciate any help

Raul

 

[SantaMufasa]

Raul,

Here is some code that you can use:

Select id
      ,username
      ,message
      ,decode(instr(message,username)
             ,0,'RECEIVED'
             ,'SENT'
             ) status
from my_table
order by id;

Let us know how this code works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.