I would like to know how to find exact word from a text data available in SQL String.
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....