Wondering if it is possible to incorporate regular expressions into a SQL statement on SQL Server? I'm only finding that Oracle supports Regular Expressions.
SQL Server supports limited pattern matching in the PATINDEX and LIKE expressions.
There's no native regex support in SQL Server, but you can expose the functionality in SQL Server 2005+ via CLR.
No, not without extra help such as writing a CLR function or something similar. T-SQL doesn't have builtin support for regular expressions.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With