Posted by ZeldorBlat on 11/09/06 17:40

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

• Next in forum: Re: Please Help With Complex Update Statement Logic
• Prev in forum: Re: Please Help With Complex Update Statement Logic
• Thread view: Re: WHERE columnName = 'this' AND anotherColumnName IS NOT NULL

[Reply to this message]