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([EMAIL PROTECTED])
Société A Comme...
Tel : 03 80 700 702
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
