# Re: select * from test where name like 'a?s*' 一问

Posted by bmf on July 22, 1999 at 15:21:31:

In Reply to: select * from test where name like 'a?s*' 一问 posted by kkcheung on July 22, 1999 at 12:25:11:

: 这个select * from test where name like 'a?s*' 应该没有问题.
: 但我想改成 select * from test where name <> 'a?s*' 便不成功,
: 应该怎样写才可得到 name<>'a?s*' 的条件式

试试下列语法:
select * from test where name not in (select name from test where name like 'a?s*')

Follow Ups: