SQL Server

Search multiple word in string using SQL server



 Like (0)  Dislike (0)

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

Submit Comment
If opportunity doesn’t knock, build a door.⛩

Popular Post

WPF

How to Use Logger in WPF Application

C-Sharp

Update Specific Users Out of Oce Settings C# with Example

C-Sharp

Retrieve Specified User''s Out of O ce Settings C# with Example

C-Sharp

Large Object Heap compaction C# with Example

C-Sharp

Weak References C# with Example

C-Sharp

Source code in the view C# with Example