SQL Server - regex filtering using LIKE, Sql Server

SQL Server - regex filtering using LIKE

--------------------------------------------------------------------------------
-- Create Sample Data
--------------------------------------------------------------------------------
WITH sample_data AS (
SELECT 0   AS [id], '123'  AS [val] UNION ALL
SELECT 1   AS [id], 'abc'  AS [val] UNION ALL
SELECT 2   AS [id], 'atc'  AS [val] UNION ALL
SELECT 3   AS [id], 'a1c'  AS [val] UNION ALL
SELECT 4   AS [id], 'abbc' AS [val] UNION ALL
SELECT 5   AS [id], 'a11c' AS [val]
)
SELECT *
  INTO [sample_data]
  FROM sample_data
;

ALTER TABLE [sample_data]
ADD CONSTRAINT [PK_sample_data]
   PRIMARY KEY([id])
;

--------------------------------------------------------------------------------
-- View All
--------------------------------------------------------------------------------
SELECT *
  FROM [sample_data]
;

--------------------------------------------------------------------------------
-- Compare Filter Expressions
--------------------------------------------------------------------------------
SELECT *
  FROM [sample_data]
 WHERE [val] LIKE 'ab%'
;

SELECT *
  FROM [sample_data]
 WHERE [val] LIKE 'a%c'
;

SELECT *
  FROM [sample_data]
 WHERE [val] LIKE 'a_c'
;

SELECT *
  FROM [sample_data]
 WHERE [val] LIKE 'a[bt]c'
;

SELECT *
  FROM [sample_data]
 WHERE [val] LIKE 'a[^bt]c'
;


run \| edit \| history \| help	0

λ

                                      .NET NoSQL database for rapid development