We help IT Professionals succeed at work.

SQL Server Query Regular Expression

I am looking for the best way to filter records from a SQL Table that do not match a regular expression.

I have a field in my DB called DriverNumber  the data should look like....E1234.  

I have the regular expression ^([ES]{1})([0-9]{4})$  

I would like to make a view in my database that displays all rows that the field DriverNumber does not match the above expression.  

I eventually will be displaying this data in Visual Studio Gridview.

Any ideas?  

thanks.
Comment
Watch Question

Senior DBA
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
WHERE DriverNumber NOT LIKE '[ES][0-9][0-9][0-9][0-9]'