急求一条SQL语句，与某糊查询相关 (100分)

H

hjy2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #1

要求得到这样的数据集
NAME字段中以“A”到“Z”打头的值，且不包括“ABC”到“ABQ”，“B”，“EE”打头的值
谢谢

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #2

name like [a-z]% and name not in ("abc","b","ee")

 

H

hjy2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #3

不包括中要求"ABC"致"ABQ",且是左打头的，上面语句不行

 

X

xgpxf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #4

select * from TableName where Name like '[A-Z]%'
and Name not in (Select Name from TableName where Name Like '[ABC-ABQ]%'or Name Like 'B%'
or Name Like 'EE%')

 

H

hjy2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #5

to:xgpxf
我是DELPHI 5 用ADO 对ACCESS97操作，这种嵌套好象不行，还有其他方法吗？
急
谢

 

Y

YNTW

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #6

select * from 表名
where (Name like "[A-Z]*")
and (Name not like "AB[C-Q]*")
and (Name not like "B*")
and (Name not like "EE*")
order by Name

 

燕

燕狂徒

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #7

同意yntw！

 

路

路茫茫

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-20

• #8

select * into #table_tmp from table where name like '[A-Z]%'
seledt * from #table_tmp where (Name not like 'AB[C-Q]*') and (Name not like 'B%') and (Name not like 'EE%')
drop table #table_tmp

 

H

hjy2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-26

• #9

谢谢各位