What is the sql statement for searching in text using MS SQL Server 2008?

Question

Hi

If I have text sotred in my DB, for example:

"There are 2 books on the table".

Maybe the user wants to search for "books" or the user wants to search in this text for any thing.

What is the best SQL Statement to do that?.

Thanks in advance.

Answer 1

SELECT ... WHERE COL LIKE '%books%'

For more complicated scenarios you might want to investigate Full Text Search

Answer 2

I think you are looking for a 'like' clause if I understand your question. so

select * from table where column like '%book%'

Answer 3

like this

WHERE ColumnName LIKE '%books%'

or look into full text search if you need to do more complicated stuff