SQL Server - regex examples, Sql Server

Language: Layout:

--------------------------------------------------------------------------------
-- Also see: https://rextester.com/FES89921
--------------------------------------------------------------------------------
-- Checking For a Date
--------------------------------------------------------------------------------
WITH sample_data AS (
SELECT 1  AS [id], '2019-01-01' AS [val] UNION ALL -- Normal Valid
SELECT 2  AS [id], '2019-01-02' AS [val] UNION ALL -- Normal Valid
SELECT 3  AS [id], '1998-01-03' AS [val] UNION ALL -- Normal Valid
SELECT 4  AS [id], 'BROKEN'     AS [val] UNION ALL -- Text
SELECT 5  AS [id], '1800-01-01' AS [val] UNION ALL -- Outside our date range
SELECT 6  AS [id], '01-06-2019' AS [val] UNION ALL -- Wrong Format
SELECT 7  AS [id], '2019-31-01' AS [val]           -- Month/Day clearly in wrong order
)
SELECT *
  FROM sample_data
WHERE 1=1
   AND [val] LIKE '[1-2][09][0-9][0-9]-[01][0-9]-[0-3][0-9]'
;

--------------------------------------------------------------------------------
-- Looking for a literal wildcard character (place it between square brackets)
--------------------------------------------------------------------------------
WITH sample_data AS (
SELECT 1  AS [id], 'a[cxyz' AS [val] UNION ALL
SELECT 2  AS [id], 'ABCX]Z' AS [val] UNION ALL
SELECT 3  AS [id], 'xyzabc' AS [val] UNION ALL
SELECT 4  AS [id], 'XY%ABC' AS [val] UNION ALL
SELECT 5  AS [id], 'ABC123' AS [val] UNION ALL
SELECT 6  AS [id], '123XYZ' AS [val] UNION ALL
SELECT 7  AS [id], '123456' AS [val] UNION ALL
SELECT 8  AS [id], '123%Y6' AS [val] UNION ALL
SELECT 9  AS [id], '123_67' AS [val]
)
SELECT *
  FROM sample_data
 WHERE 1=1
   AND(   [val] LIKE '%[%]%'
       OR [val] LIKE '%[_]%'
       OR [val] LIKE '%[[]%'
       OR [val] LIKE '%]%'
      )
;

View schema
Execution time: 0 sec, rows selected: 8, rows affected: 0, absolute service time: 0,17 sec, absolute service time: 0,17 sec