Avatar of rgb192
rgb192
Flag for United States of America asked on

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

Avatar of undefined
Last Comment
rgb192

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Aneesh

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

Is that showing any syntatic error, If so please post the error.
rgb192

ASKER
thanks
Your help has saved me hundreds of hours of internet surfing.
fblack61