[PHP-WIN] RE: [PHP] Nulls in database

2001-02-01 Thread Carlos Andre Marques Moreira
Actually you should use is null, or is not null (if you want to retrieve the rows that don't have null values), either uppercase or lowercase. Your query should be something like that: SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion Date] FROM common WHERE [Start Con

[PHP-WIN] Re: [PHP] Nulls in database

2001-02-01 Thread Juan
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 t