>>Suppose you have a SQLPT view that includes a datetime field from a SQL Server table. Suppose also that you want the field in the view to be of type Date, not datetime. Can it be done?
>>
>
>You can use ALTER TABLE command if there're no fields in the cursor with name longer than 10 charcters.

ALTER TABLE mySPTcursor ALTER COLUMN mydatetime D

Sergey,

Thanks for what sounds like a wonderful idea. Unfortunately it causes error 1525, "Function is not supported on remote tables", even though I am trying to change the view, not the table. Anything I missed?

Alex