On Fri, 11 Mar 2005 10:37:13 +1300, Mark Kirkwood <[EMAIL PROTECTED]> wrote: >Firebird 1.5.1 FreeBSD 5.3 >[correct results]
Interbase 6.0: SQL> create table tab (col integer); SQL> select 1 from tab having 1=0; SQL> select 1 from tab having 1=1; ============ 0 <------- :-) SQL> insert into tab values(1); SQL> insert into tab values(2); SQL> select 1 from tab having 1=0; SQL> select 1 from tab having 1=1; ============ 1 SQL> Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])