In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its usage and provided several examples with it. In this article, we are going to discuss the SUBSTRING, PATINDEX, and CHARINDEX functions of T-SQL. These functions can be used to perform pattern matching. Read More
Tag: sql regular expression
T-SQL Regular expression: LIKE Operator and its use-cases.
A regular expression is a rule which defines how characters can appear in an expression. It’s a sequence of character or text which determines the search pattern. In SQL databases, selecting values based on regular expressions defined in the WHERE condition can be very useful. Following are a few use cases of how you can use regular expressions. Read More
T-SQL Regular expression: LIKE Operator and its use-cases
A Regular Expression (Regex) is a rule defining how characters can appear in an expression. In essence, it is a sequence of characters or text, which determines the search pattern.
The following are some of the use cases for regular expressions:
- To identify the data using combinations, such as credit or debit card numbers, email addresses, or telephone numbers.
- To find a specific text pattern or apply a filter to the text, numeric, or special character data.
- To parse the data in ETL by creating rules for inbound and outbound traffic and finding patterns in the code.
In SQL databases, selecting the values based on regular expressions defined in the WHERE condition is very useful.
Read More