boolean

hello list,

if i have a table foo with a column called bar of type boolean
and if i insert into foo (foobar) values('bar') without
explicitly inserting a value for bar, the bar column of this
particular row will be empty. it's neither 't' nor 'f'.

i can select all rows where bar eqals to 't' and all
rows where bar equals to 'f'.

But I want to know, how I can select all rows which neither
match 't' nor 'f' ? To perform an update like

UPDATE foo SET bar='t' WHERE bar=null;

or anything similar. What syntax can I use?

thanks for your help

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------