Re: Query about Boolean Data Type

--On Friday, August 08, 2003 10:29:37 +0100 Richard Hurst
<richard(dot)hurst(at)kirklees(dot)gov(dot)uk> wrote:

> Hi
>
> This may seem a bit simplistic but how do you match a select on a
> boolean data column where the entry is false or null
select * from table where field='f' or field is null;

should do it.

>
> Thanks
>
> Richard
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749