Ah, did not think of SQL syntax, thank you. Florian > > Unfortunately I need "0" as a value and I can not set the existing > records > > to <NULL> since this is not a valid value in Director. > > > > > > > > What now? > > Well, you can do > > UPDATE T SET fld = NULL >