SQL Server REGEX Complete Tutorial with Practice Exercises

Partner: Udemy
Affiliate Name:
Area:
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 rangeAll 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.ProductExamples - -- % - 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 HExample 12 -     Product NUmber not starting between A to H. Example 13 - Data(Size) is Only One Character and Value is from A to Z
Category: IT & Software > Other IT & Software > SQL
Partner ID:
Price: 19.99
Commission:
Source: Impact
Go to Course