SQL question
From: David Moore <davidmo_at_rossinc.com>
Date: Tue, 28 Dec 1993 00:31:00 GMT
Message-ID: <1993Dec28.003100.13471_at_rossinc.com>
Date: Tue, 28 Dec 1993 00:31:00 GMT
Message-ID: <1993Dec28.003100.13471_at_rossinc.com>
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??
Thanks,
Dave
-- ============================================================= David A. Moore | Phone: (415) 593-2500 Ross Systems Inc. | E-mail: davidmo_at_rossinc.comReceived on Tue Dec 28 1993 - 01:31:00 CET