SQL: CASE WHEN LIKE RegEx example

case-when-like-regex.sql

-- Update with RegEx
UPDATE t
SET 
	[someField] = 
		CASE 
			WHEN LEFT(t.[postal_code], 3) LIKE '%[a-z][0-9][a-z]%'
			THEN 'Canadian Value'
			WHEN LEFT(t.[postal_code], 3) LIKE '%[0-9][0-9][0-9]%'
			THEN 'US Value'
			ELSE NULL
		END
FROM [dbo].[someTable] t
WHERE 1=1
	AND t.[country] IN ('US', 'Canada')
;

-- Delete with RegEx
DELETE FROM [dbo].[someTable]
WHERE 1=1
	AND (
		[email] NOT LIKE '_%@_%.__%'
		OR [someField] IS NULL
		OR [someField] NOT LIKE '%SomeString%'
	)
;