Better way to write "like operator" in SQL Server

Question

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%'

Answer 1

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]%'