I have a remote view going against SQL server. If I try to update a record that had a null date field with a non-null date, I get an update conflict. This is because the remote view is sending a SQL command that looks like this:
UPDATE ordercomments set tedited = 'Apr 29 2002 11:44AM'where uordcommid=1 and teditedon=SPACE(23)
The problem is the teditedon=SPACE(23) condition will never find my null date. How can I tell the remote view to send