SQL Server Regular expressions in T-SQL

by

How about the PATINDEX function?

The pattern matching in TSQL is not a complete regex library, but it gives you the basics.

(From Books Online)

Wildcard  Meaning  
% Any string of zero or more characters.

_ Any single character.

[ ] Any single character within the specified range 
    (for example, [a-f]) or set (for example, [abcdef]).

[^] Any single character not within the specified range 
    (for example, [^a - f]) or set (for example, [^abcdef]).

More Related Contents:

  1. Using RegEx in SQL Server
  2. Comma separated results in SQL
  3. T-SQL stored procedure that accepts multiple Id values
  4. Understanding PIVOT function in T-SQL
  5. How do I escape a percentage sign in T-SQL?
  6. Replace duplicate spaces with a single space in T-SQL
  7. How do you count the number of occurrences of a certain substring in a SQL varchar?
  8. How much size “Null” value takes in SQL Server
  9. SQL Server: Isolation level leaks across pooled connections
  10. How do I use the CONCAT function in SQL Server 2008 R2?
  11. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  12. How do I exclude Weekend days in a SQL Server query?
  13. Scheduled run of stored procedure on SQL server
  14. SQL Server ORDER BY date and nulls last
  15. EXEC sp_executesql with multiple parameters
  16. Preserving ORDER BY in SELECT INTO
  17. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  18. Can you call a webservice from TSQL code?
  19. How to add custom attributes to SQL connection string?
  20. Multiple Column Pivot in T-SQL
  21. Convert decimal time to hours and minutes
  22. Joining multiple tables returns NULL value
  23. Which join syntax is better?
  24. Compute MD5 hash of a UTF8 string
  25. LPAD in SQL Server 2008
  26. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  27. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  28. How do I remove non-breaking spaces from a column in SQL server?
  29. Is there an “IF EXISTS” test for a linked server?
  30. SQL Server stored procedure return code oddity

Leave a Comment