Search for text string 1

[bergis]

Hi,
in a database I am working with there is a field where the data entered by the users are an description of an operation they are doing, Its in a table called OPSUM, and the main fields are PHASE, TASK and ACTIVITY, these contain a code to describe what they were doing, and then there is a fourth field; OPER, which contains text to describe the operation. I want to search this field for occurrences of a particular text string (in this case "test bop", where TASK="BOP" and ACTIVITY="a". Does anyone know what kind of expression I have to use to search for a word anywhere inside a text string?
thanks
Kjell

 

[tlbroadbent]

You can use the INSTR function or the LIKE predicate.

Select *
From Table
Where Instr([OPER],"test bop&quot>0

Select *
From Table
Where OPER Like "*test bop*" Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.