Reputation: 59

Better way to write "like operator" in SQL Server

Is there any better way to re-write the below code?

SELECT * 
FROM PROFILE 
WHERE GRP_NUMBER NOT LIKE '2%' AND GRP_NUMBER NOT LIKE '7%'

Upvotes: 0

Answers (3)

Spider

Reputation: 524

Try below sample

DECLARE @Table TABLE(
        Col VARCHAR(50)
)

INSERT INTO @Table SELECT '2ABC' 
INSERT INTO @Table SELECT '4Italy2' 
INSERT INTO @Table SELECT '3Apple' 
INSERT INTO @Table SELECT '234.62' 
INSERT INTO @Table SELECT '2:234:43:22' 
INSERT INTO @Table SELECT '7' 
INSERT INTO @Table SELECT '6425.23'
INSERT INTO @Table SELECT '2' 
INSERT INTO @Table SELECT 'Lions'


SELECT * FROM @Table
WHERE Col NOT LIKE '[27]%'

Upvotes: 1

AswinRajaram

Reputation: 1632

  SELECT * 
  FROM PROFILE
  WHERE GRP_NUMBER NOT LIKE '[27]%'

Upvotes: 0

Denis Rubashkin

Reputation: 2191

SELECT * 
FROM PROFILE
WHERE GRP_NUMBER LIKE '[^27]%'

Upvotes: 2

Better way to write &quot;like operator&quot; in SQL Server

Answers (3)

Related Questions

Better way to write "like operator" in SQL Server