Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 exclude some values

Author  Topic 

mary_itohan
Posting Yak Master

191 Posts

Posted - 2005-11-10 : 06:17:01
hello
how do i exclude some values from my search criteria

select * from users where username <> 'me' or <> 'you'

pls help

Yes O !

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-10 : 06:20:15
Try these

1 select * from users where username <> 'me' and username <> 'you'
2 select * from users where username not in('me','you')


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -