SQL Regular Expressions and Pattern Matching, Wildcards
What you will learn
Learn SQL REGEX operations in SQL Server (match on single/multiple , alpha/numeric characters) , position specific matches
Understand different kinds of wildcards for Regular Expression.
Write SQL Queries for Pattern Matching.
Master Regex expressions with lots of Practice Exercises.
Description
In this course, we will learn about SQL REGEX operations in SQL Server database.
We will learn about pattern matching and how to use the wildcards.
We will learn how to use the following wildcards –
% – Any string of zero or more characters.
_ (underscore) Any single character.
[ ] Any single character within the specified range
[^] Any single character not within the specified range
All examples are base don the AdventureWorksLT database from Microsoft.
The table is SalesLt.Product.
You can download it from the Microsoft Website.
Select * from SalesLT.Product
Examples –
— % – Any string of zero or more characters.
Example 1 – Name with ‘Bike’
— _ (underscore) Any single character.
Example 2 – Second character is ‘R’
— Third character is ‘-‘ and 4th character is ‘U’
Check for Product Number pattern
Example 3 – Any 2 characters followed by ‘-‘ followed
Example 4 – by any 4 characters followed by ‘-‘ followed
Example 5 – by any single character – HL-U509-R
— [ ] Any single character within the specified range
Example 6 – Above pattern with last char L or M
Example 7 – Above pattern with last char between L and S
Example 8 – Above pattern with last char between L and R
— [^] Any single character not within the specified range
Example 9 – Above pattern with last char not between L and R
Example 10 – Product number not starting with F
Example 11 – Product number not starting with F or H
Example 12 – Product NUmber not starting between A to H.
Example 13 – Data(Size) is Only One Character and Value is from A to Z
Example 14 – Data(Size) is Two Characters and Values are from A to Z
Example 15 – Text(rowguid) Rows Starting with a Number
Example 16 – Find a Number Pattern –
— Product Number with 4th and 5th chars as numbers
Example 17 – Number(List Price) with two decimal places ending in 2
— Using the Not Character for Regex with T-SQL
Example 18 Product Number – after 1st hyphen has either numbers or special characters
Example 19 – Name has Only alphabetic characters
Example 20 – Name has No special characters
Content