Home > IT Answers > Development > String Search in Oracle SQL
Trinaa
0 pts.
 String Search in Oracle SQL
SQL
Hi all, I need to scan a field for a specific string and exclude all records with that specific string. This string in the filed looks like this: 'WRK 08:06, LNCH 00:54, GRACE 00:02' I want to excule all records containg "LNCH" in the time_code field. I tried like but that does not seem to work. Can anyone help? Thanks

Software/Hardware used:
ASKED: October 28, 2004  7:24 PM
UPDATED: October 28, 2004  10:45 PM
RELATED QUESTIONS
Answer Wiki:
Hi, you can try this: SELECT ... FROM ... WHERE ... AND NOT INSTR(<your_field>, 'LNCH') > 0
Last Wiki Answer Submitted:  October 28, 2004  8:55 pm  by  Rsteinkampf   0 pts.
All Answer Wiki Contributors:  Rsteinkampf   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _