>I apologize since I know this has been answered before (most probably by Sergey ;) ), but I forgot to file it in my tips folder.
>
>I'm retrieving SQL Server data using SPT to a cursor which contains, among other things, a datetime field. I have a textbox control in a grid that I would like to use for displaying this field as a date only. How do I achieve this? Changing the SELECT statement to convert the datetime field to a style of 101 doesn't help at all. Am I to use TTOD() somewhere in this?
>
>Laterness,
>Jon

I know how to do this with a remote view. Did you try ALTER TABLE to change the field from a datetime to a date field?

BOb