Sam OZ

<div>
Are you using CLR integration to load your own DLL into SQL Server, because SQL Server doesn't not support regex out of the box, and the only way to get that is by referencing a .NET library that provides such.
</div>


Are you using CLR integration to load your own DLL into SQL Server, because SQL Server doesn't not support regex out of the box, and the only way to get that is by referencing a .NET library that provides such.

<div>
<div class="content wysiwyg-content">
I need regular expression for following in Sql Server ( I hope it is same in vb.net or c#)<br />
I am looking for a pattern &nbsp;someletters somenumbers &nbsp;some letters- someletters somenumbers &nbsp;some letters &nbsp; &nbsp; ( All capital letters)<br />
&nbsp; examples &nbsp;AA111WW-B123SS<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AB1DFG-S3ERT<br />
<br />
&nbsp; &nbsp;Another pattern I am looing is &nbsp; somenumbers someletters somenumbers -someletters<br />
&nbsp; &nbsp; &nbsp;examples &nbsp; 11AAA123-SDFG<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1AB23-AB
</div>
</div>


I need regular expression for following in Sql Server ( I hope it is same in vb.net or c#)
I am looking for a pattern  someletters somenumbers  some letters- someletters somenumbers  some letters     ( All capital letters)
  examples  AA111WW-B123SS
                      AB1DFG-S3ERT

   Another pattern I am looing is   somenumbers someletters somenumbers -someletters
     examples   11AAA123-SDFG
                          1AB23-AB

Regular expression for given pattern

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.