Posted by jojowebdev on 11/09/06 17:01

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

• Next in forum: Re: Please Help With Complex Update Statement Logic
• Prev in forum: How to loop through this sql table and display in ms access listbox
• Thread view: WHERE columnName = 'this' AND anotherColumnName IS NOT NULL

[Reply to this message]