set criteria in a query based on if a string contains a certain string

[tkaplan]

Good afternoon

I am trying to create a select query with the criteria for one of the fields being if anywhere in the text of the record it contains the word "computed". I can't figure out how to set that criteria. I was thinking of searching for the string and if it returns a value greater than 0 then it meets criteria, but i can't find the function that does that.

Thanks in advance!
Tkaplan

[jonh]

Hi

select * from YourTable
where instr(FieldToCheck,'computed')<>0

[tkaplan]

Thank you!