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>


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.com
Received on Tue Dec 28 1993 - 01:31:00 CET

Original text of this message