How to convert a field date to null or empty.
In this trigger doesn't work, causes this message:

'Overflow occurred during data type conversion.
Conversion error from string "".'

ALTER TRIGGER AUX_2 ACTIVE before insert POSITION 0
AS

begin
if ( new.dt_creation ='01/01/00' ) then
new.dt_creation = '';

end

[]'s
Alessandro.....