WHERE columnName = 'this' AND anotherColumnName IS NOT NULL

#1 (**permalink**) 03-01-2008, 11:33 AM

Using SQL Query Analyzer how do I do something like:

WHERE columnName = 'this' AND anotherColumnName IS NOT NULL

I.E.
SELECT *
FROM CES_DATA
WHERE DIV = 'MW'
AND Not IsNull RO
ORDER BY RO

#2 (**permalink**) 03-01-2008, 11:33 AM

jojowebdev@gmail.com wrote:
> Using SQL Query Analyzer how do I do something like:
>
> WHERE columnName = 'this' AND anotherColumnName IS NOT NULL
>
> I.E.
> SELECT *
> FROM CES_DATA
> WHERE DIV = 'MW'
> AND Not IsNull RO
> ORDER BY RO

You were close:

select *
from CES_DATA
where DIV = 'MW'
and RO is not null
order by RO

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode