>

>IIF(ISNULL(DatetimeColumn), {}, TTOD(DatetimeColumn))
>

Wouldn't NVL(DateTimeColumn, {//:}) be simpler?

>>I'm upsizing an application which now uses local views to use remote views (but only in some installations, where network traffic is intensive and the application now is too slow) to access SQL Server data, depending on the DBC distributed, which will contain only local views or remote views.
>>The goal is to change as less code as possibile.
>>
>>The problem I'm facing is about Datetime fields.
>>In code I often refer to them testing for their EMPTY() value (not ISNULL()) and store them as empty datetime values.
>>I can now send (Upload) NULL value to SQLServer tables, using the Properties button in the remote view designer with default = NULL.
>>
>>I'm asking now for a speedy way to test for NULL values in data 'Downloaded' from SQL and convert them in Empty values {//::} so as leave most of code unchanged.
>>
>>TIA.
>>Bruno