Hello,

An application that runs fine with SQL Server 6.0 uses Visual Basic 4.0 RDO
(RDO-Patch applied) to access the data.  Under SQL Server 6.5 (U.S. with
Service Pack 1) a select statement using a null in the where clause does
not work (select * from x where y = null).

Has anyone experienced this problem or knows of a solution?

Hello,

An application that runs fine with SQL Server 6.0 uses Visual Basic 4.0 RDO
(RDO-Patch applied) to access the data.  Under SQL Server 6.5 (U.S. with
Service Pack 1) a select statement using a null in the where clause does
not work (select * from x where y = null).

Has anyone experienced this problem or knows of a solution?

Should be: select * from x where y is null

I thought you needed to use the "is null" construct:

select * from x where y is null;

select * from x where y is null

(or select * from x where NOT y IS null)

This is claimed to be a "more ANSI" syntax, and acquired habits and
practices of developers do not count... So, where do you want to go
today?