About
Pricing
Community
Teams
Start Free Trial
Log in
rgb192
asked on
2/15/2010
select * from table1 where column1 is not null
select * from table1 where column1 is null
this works
but I want to do
the other values
select * from table where column1 is not null
Microsoft SQL Server 2005
3
1
Last Comment
rgb192
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Aneesh
2/15/2010
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Deepandp
2/15/2010
Is that showing any syntatic error, If so please post the error.
rgb192
2/15/2010
ASKER
thanks
Your help has saved me hundreds of hours of internet surfing.
fblack61