Preserved Topic: contains (Page 1 of 1)

Is it possible to do a query to a database for data "containing" something the user types in. Kind of like searching for help topics?

Any help is appreciated

Ensa

strSQL = "select * from table where fieldName like '%" & strSearchTerm & "%'"

should do the trick for you (where strSearchTerm is the previously entered search text)
a word of warning though - this sort of query takes longer to run than a simple "select * where field=x" type query, but if run it over a fairly small database, there shouldnt be too many problems

hth
I:.