Sorry,

The field in the table contains a whole load of text eg.

'Coloured bits and bobs for use in the home'

so searching for 'red' would bring up that product using the Like with the % wildcards. However knock out the % and it wouldnt return that product unless the entire 'coloured bits and bobs for use in the home' was entered as the search term.

What im after is for it to search for complete words so searching for 'red' wouldnt return this product but searching for coloured would