Re: Another angle on this....

Every night before I go to bed ... I pray for software ... just as it is.

If it were better I'd probably have to get a real job.

Daniel Morgan

Brian Dick wrote:

> "damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
> news:3C7435AD.A754FB7C_at_ci.seattle.wa.us...
> > SELECT 'x'
> > FROM mytable
> > WHERE null = null;
>
> That doesn't return anything in SS or Sybase, today. I've lost too many
> brain cells to remember if past versions did so. They also correctly join
> tables on columns with nulls and omit those rows.
>
> But what is true is that SS and Sybase allow you to write non-standard SQL
> that I detest
>
> SELECT 'x'
> FROM mytable
> WHERE col1 = null;
>
> And they will return rows where col1 IS NULL.
>
> All RDBMS's have warts and blemishes. It's what keeps us pros in business
> <g>.
>
> --
> Later,
> BEDick
Received on Wed Feb 20 2002 - 19:01:13 CST