Dear Friends,

I would like to know how to find exact word from a text data available in SQL String.

I mean,

Suppose I have a string available in Table1; ie , "My latest activities"

I want to search the word like test.

Currently I am using query

select * from Table1 where subject like "%test%"

That time it is showing the subject like above because of 'latest'. But I want the rows that exactly contains the word test.

Kindly help me....