Search multiple word in string using SQL server



The PATINDEX() function returns the position of a pattern in a string. If the pattern is not found, this function returns 0.

  1. select * from [tbl_comments] where PATINDEX('%|%', title) + PATINDEX('%gEt%', title) + PATINDEX('%c#122%', title)  > 0  

0 Comment's

Comment Form