Like operator in sql server

Posted by Geetha on Stack Overflow See other posts from Stack Overflow or by Geetha
Published on 2010-03-25T04:47:55Z Indexed on 2010/03/25 4:53 UTC
Read the original article Hit count: 421

Filed under:
|

Hi All,

i want to get all the record from the database which contain atleast one word from the input string.

Ex: input=Stack over flow

select * from sample where name like '%stack%' or name like '%over% or name like '%flow%'

Geetha.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about like-operator