Search code examples
c#sql-server-2008-r2patindex

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
Solution

  • 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.