CODEWITHSUNDEEP
c#sql-server-2008-r2patindex
Sunil
Sunil

Reputation: 21396

C# equivalent of PATINDEX function in SQL Server 2008

I have the following SQL Server code which I would like to do in C# code. The logic is - if the pattern '%SELECT %FROM% is found in a string called 'x', then I need to return. The '%' stands for 0 or more characters.

The part I am not getting is how to translate the first line of code into C#?

 IF PATINDEX('%SELECT %FROM%',  @x ) > 0 
  BEGIN
     RETURN;
  END

Upvotes: 1

Views: 3034

Answers (1)

Vulcronos
Vulcronos

Reputation: 3456

Take a look at regular expresions for C# and the match function..

The pattern would be something like 

.*SELECT .*FROM.*

where .* stands for anything other then a new line.

Upvotes: 3

Related Questions