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.
| Author |
Topic |
|
newuser123
Starting Member
7 Posts |
 Posted - 2010-04-08 : 08:01:50
|
| Following WHERE clause will work in SQL? select * from status_tblwhere (status = 'active' OR status = 'reject' OR status = 'In Progress') |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-08 : 08:04:50
|
yup. but short way isselect * from status_tblwhere status IN ( 'active','reject','In Progress') ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
newuser123
Starting Member
7 Posts |
Posted - 2010-04-08 : 08:06:26
|
| will work or not...where (status = 'active' OR status = 'reject' OR status = 'In Progress') |
|
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-04-08 : 08:13:23
|
| Hi,It will work, but it is not the correct way.You should use like visakh said.Regards,Sathieshkumar. R |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-08 : 08:22:19
|
quote:
Originally posted by newuser123
will work or not...where (status = 'active' OR status = 'reject' OR status = 'In Progress')
Why dont you try it and see for yourself  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
WHERE Clause