The Regular Expressions for MS SQL Server offer an extremely powerful way to search, replace, format and extract text data inside a string using sophisticated search criteria. For example, you can search for whole words, or find a match with some pattern (e-mails, phone numbers, postal codes, etc.), and can quickly locate, count and extract all the occurrences from the searched string.