query question

[tyris]

hi all,
i do have a field in a database called description. its type is text(up to 255 char). what i'd like to know is if there is a way to make a search of a text that could be included in this field.

for exemple to make a query like :

select * from myDB where description contains "a string"

is it possible ? Best regards X-),
Elise

 

[tlbroadbent]

Yes, it is possible. Use the Like predicate and the % wildcard in the criteria.

select * from myDB where description Like '%a string%' Terry

X-) "Life would be easier if I had the source code." -Anonymous

 

[tyris]

cool ) thanks a lot Best regards X-),
Elise