On 14/01/2008, Andy Shellam <[EMAIL PROTECTED]> wrote: > > That doesn't prove it's null - it proves it's null OR 1900-01-01 > > 00:00:00+00. However, the <NULL> output option is onlt for the Query > > Tool. The data entry grid always displays an empty cell for NULL, '' > > for a blank string, and \'\' for a pair or single quotes. From the > > docs: > > > I knew it was NULL cause the table only had 1 row in it, and I'd purposely > set it to NULL through a query ;-)
My point is still valid though, and as you didn't mention those details earlier... :-) Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend