Case sensitive

[zongyaoou]

Thanks for your code , it helps me a lot .
Since I'm not familiar with C# , I don't konw how to set the case sensitive off .
Could you please help me ?
Thanks!

[DevNambi]

That's a great question. At the moment there isn't a way to turn off case sensitivity in the sql-server-regex; it's an option flag to Regex.Match() in C#, but there isn't a way to pass that option in to the function.

There's a workaround available by including both lowercase and uppercase in the regular expression itself. https://stackoverflow.com/questions/9655164/regex-ignore-case-sensitivity describes that a little bit.

[spointeau]

we can use an option in the regex template, for exemple:
select c.RegexMatch('aBC', '(?i)^a.*c$') returns aBC

whereas select c.RegexMatch('aBC', '^a.*c$') returns null