Re: Nulls in database

Réponse au message | [PHP] Nulls in database | du jeudi 1 février 2001, 18:05 : This is from memory concerning my old SQL class but isn't there something specific in sql lines saying that to find null values you should use : ISNULL Since an empty string is different from a null entry. CR> I am trying to write a query to bring back rows that have null values set in CR> them. I cannot figure out how to do this. I can bring back all rows that do CR> not have nulls with the following query. CR> SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion CR> Date] CR> FROM common WHERE [Start Construction Date] != ' ' OR [Actual Completion CR> Date] != ' ' CR> I tried changing the != to = but it does not return anything. CR> I am running these queries off a MSSQL 7.0 Server CR> Ryan _______________________________________ Massuelles Jean-Baptiste(Juan@acomme.fr) Société A Comme... Tel : 03 80 700 702