IF OBJECT_ID('tempdb..#Test', 'U') IS NOT NULL DROP TABLE #TEST
CREATE TABLE #Test
(
  RecordId int identity(1000, 1) PRIMARY KEY,
  Value varchar(100)
)
SET NOCOUNT ON
INSERT INTO #Test (Value) Values ('cse-12m')
INSERT INTO #Test (Value) Values ('cse-343k')
INSERT INTO #Test (Value) Values ('cse-mka')
INSERT INTO #Test (Value) Values ('cse-ptu')
INSERT INTO #Test (Value) Values ('cse-jpy')
INSERT INTO #Test (Value) Values ('cse-123')
SET NOCOUNT OFF
 
--#1 - Matches cse-NNN, Does NOT match cse-123k
SELECT *
FROM #Test
WHERE Value LIKE 'cse-[0-9][0-9][0-9]'
 
--#2 - Matches cse-NNN*, so anything beginning with "cse-NNN" is matched
SELECT *
FROM #Test
WHERE Value LIKE 'cse-[0-9][0-9][0-9]%'
 
--#3 - Invert #1
SELECT *
FROM #Test
WHERE Value NOT LIKE 'cse-[0-9][0-9][0-9]'
 
--#4 - Invert #2
SELECT *
FROM #Test
WHERE Value NOT LIKE 'cse-[0-9][0-9][0-9]%'