> CREATE TABLE TEST ( ID NUMBER, NAME CHAR(30) );
> INSERT INTO TEST (ID,NAME) VALUES (1,'');
> SELECT ID,NAME FROM TEST WHERE NAME IS NOT NULL;
>
> Returns no rows whereas it should under SQL92 compliance return (1,'')
>
> Do MS-SQL, Interbase, Postgress, etc suffer the same limitation.
MSSQL treats '' as ' ' (blank string as a string with a space), and
therefore the above returns one record. So, if you want to insert a blank
string, you will need to insert a null (quite a pain). I think there is a
server switch that can turn this behaviour off, and if you do that, the
above query will return no results.
Regards,
Dennis.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
