At 11:14 AM 7/09/2005 +0100, you wrote:

>If you mean empty rather than containing spaces do this
>select * from table where column is null
>
>If you mean empty spaces do this
>select * from table where column =' '

Not for dates. A date/time type column is either a valid date/time of the
defined type or it is null. There is no such thing as "a blank date".

./hb