ASP keyword search.

[em00guy]

How do I construct a SQL statement that will search db fields for certain words that are contained in that field.

[bmcgee]

sSql = "SELECT * FROM mytable WHERE field1 LIKE '%cat%' AND field2 LIKE 'bird%'

%cat% will find: "cat", blackcat", "catbird", and "scathing" (i.e. anything with "cat" in it)

bird% will find: "bird", "birdie", but NOT "catbird" (i.e. anything starting with "cat")

Just a warning, using the LIKE statement will hurt your database performance, as it causes a full scan and cannot use the indexes on your fields.

[em00guy]

sorry for the delayed gratitude but thanx.