--------------------------------------------------------------------------------
-- 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
FROM [sample_data]
-- Compare Filter Expressions
WHERE [val] LIKE 'ab%'