sql regular expression Archives

T-SQL Regular Expressions: SUBSTRING, PATINDEX and CHARINDEX

September 29, 2019September 30, 2019 Nisarg Upadhyay Leave a comment

Total: 9 Average: 4.3

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

T-SQL Regular expression: LIKE Operator and its use-cases.

August 9, 2019September 25, 2019 Nisarg Upadhyay 1 Comment

Total: 12 Average: 3.7

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

August 9, 2019January 20, 2021 Nisarg Upadhyay 1 Comment

Total: 1 Average: 5

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.