>You should also be aware that if you have any blank date fields that they will be changed to 12/30/1899 or possibly 1/1/1900 in SQL Server, since ODBC has no concept of blank dates.

Thanks for the info, which I'll put to good use. I use MSDE 7.0 and it seems to map an empty date in the view to (1/1/1900} in SS and viceversa. When would it be converted to 12/30/1899 in SS? Do you know of documentation about this behavior?


>As far as changing code globally, you can use GOFISH app from downloads to search for occurrences of specific text and change it using its edit capabilities. Much faster and less error prone than manually searching and editing multiple files.
>
>Or, as Sergey suggested, you can map your datetime fields to date data type in your remote views and your code needs no changes except to handle the blank dates being replaced with a default date.

I've opted for handling it at the view level which is easier for my purposes.

Thank you very much for your response.

Alex