C# equivalent of PATINDEX function in SQL Server 2008

Question

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

You can post some sample code please?

Sunil
– Sunil

2013-09-30 21:27:38 +00:00
Commented Sep 30, 2013 at 21:27 — Sunil
– Sunil, Commented Sep 30, 2013 at 21:27

Vulcronos · Accepted Answer · 2013-09-30 21:27:21Z

3

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.

answered Sep 30, 2013 at 21:27

Vulcronos

3,4563 gold badges19 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sunil Over a year ago

Thanks your pattern is perfect. One needs to always replace % in SQL Server pattern with .* in C# Regex. That rule is always true it seems.

Vulcronos Over a year ago

The one gotcha is that .* won't match new lines by default. If you want .* to match new lines then you need to use RegexOptions.Singleline.

Sunil Over a year ago

Ok. I will try that out.

Sunil Over a year ago

Vulcranos - You are a genius. Your advice is worth a million points. Thanks for that excellent tip on RegexOptions.Singleline

Collectives™ on Stack Overflow

C# equivalent of PATINDEX function in SQL Server 2008

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related