Hi Fred,

>>>>>Is there a way to convert datetime to date fields in SPT cursor?
>>>>
>>>>Would TTOD() do what you want?
>>>>
>>>>SELECT TTOD(tMyDateTime) AS dMyDate...
>>>
>>>You can only use functions that the back end will understand for SPT. I think CONVERT() may be what's needed here.
>>
>>CONVERT() doesn't work either because SQL Server doesn't have a date datatype. I posted the same question a couple of days ago and the answer seems to be NO. You can do it with Remote Views, but not SPT cursors.
>
>How many records in your result set? Would an extra SELECT with the TTOD() from the SPT result cursor into a new cursor be prohibitive?

In this case, only one! So, the second Select IS a possibility. I was also trying to see if I could handle the general case where more results might be returned.
Thanks.