SUMMARY: SQL question

Thanks for all the replies I received.

The reason I asked the question was that when I use SQL with RDB on VMS and Ingres on Unix, the following statements always give the same results:

SQL> select count(*) from table_one where field_one = '';

SQL> select count(*) from table_one where field_one = ' ';

I guess this means that RDB and Ingres are incorrect!?! :-)

Thanks again,

Dave

P.S. Does anyone know of an archive site where I can find a copy of

      the latest SQL standard??

>I performed the following queries, searching for blank character fields:
>SQL> select count(*) from table_one where field_one = '';
> COUNT(*)
>----------
> 0
>SQL> select count(*) from table_one where field_one = ' ';
> COUNT(*)
>----------
> 21
>Can someone explain to me why the first query does not work and the
>second one does??

-- 
=============================================================
David A. Moore		| Phone:   (415) 593-2500
Ross Systems Inc.	| E-mail:  davidmo_at_rossinc.com
-- 
=============================================================
David A. Moore		| Phone:   (415) 593-2500
Ross Systems Inc.	| E-mail:  davidmo_at_rossinc.com