>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
--sb--