WHERE columnName = 'this' AND anotherColumnName IS NOT NULL

[jojowebdev]

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

[ZeldorBlat]

jo********@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