Having a complete mental block on this. I'm trying to search a recordset from the SQL:<BR><BR>strSQL="select * from table where field like '%" & strSearch & "%'"<BR><BR>This works well up to a point - but I'd like it search for whole words only. At the moment a search for 'art' returns records with earth or apartment in it. I'd like it to only return records with the whole word 'art' in it. Any pointers would be appreciated.