select * from q:\qa\qdms2000\qdms!document where title like l_cSearchtext
   into cursor temp

where l_cSearchText = "%some_value%"

Preceding and ending the string with the percent sign is the SQL way of looking for that string anywhere in the field.

Value% means the beginning of the field has to start with the value but acn end with anything.

__Value [that is value preceded by 2 underlines] means the first 2 characters can be anything. 1 Underscore per character [DOS equivalent to ? per character].

where LastName like Sm_th% would find all like Smith, Smythe, Smithsonian, etc.