在pubs数据库的titleauthor表，要求查询出au_id的值不必以8开头，但必须包含字符8的所有记录

declare @t table(au_id int)

insert into @t values(800)
insert into @t values(108)
insert into @t values(8)
insert into @t values(12800)
insert into @t values(18888)
insert into @t values(123)
insert into @t values(279)

select * from @t

select * from @t
where au_id like '[^8]%8%'

---------------------------------------

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
au_id
-----------
800
108
8
12800
18888
123
279

(7 row(s) affected)

au_id
-----------
108
12800
18888

(3 row(s) affected)