I have a trigger which for some reason is inserting a Null value as a 12:00AM time. What I have is this:<BR>Declare @PupTime as datetime<BR>Declare @DelTime as datetime<BR>Select @PupTime = Null<BR>Select @DelTime = Null<BR><BR>Now my update statement is in an EXEC() statement which does something similar to this.<BR><BR>exec('Update puptime = ''' + @PupTime + ''' where [Criteria]')<BR><BR>It won't allow me to only use single quote I have to use 3 single quotes to get it to run and everything else actually works great if there is a value for @PupTime but Null goes in as a 12:00AM time. Any idea what I am doing wrong. Thanks. I need to use the exec because there is dynamic loop involved.