I'm trying to make a little search engine for a site I'm working on. The basic query looks like:<BR><BR>SELECT * FROM Table1 WHERE Field1 LIKE '%paint%'<BR><BR>This works ok execpt it returns fields with the words paint, painter, paints, etc. I want only records with the world 'paint'. So I changed it to this:<BR><BR>SELECT * FROM Table1 WHERE Field1 LIKE '% paint %'<BR><BR>This returns records with only the word paint with a space on each side. This only works if the word is not at the end of the begining of the field. How can make it find the word if it comes and the begining or the end?