nope,
is SQL server view

>You are creating a VFP view, rather than a SQL Server view? If so, you can set the property of the field in the VFP view to change the field from a datetime to a date. I forget the exact syntax, but it's something like:
>
>DBSETPROP(FieldNameHere, "FIELD", "Type", "D")
>
>>no,
>>a DATETIME field to a DATE.
>>In other workds I want to use a TTOD() function in SQL server.
>>
>>The reason I want to do this is because I'm creating a SQL view, so that when I get all the fields in my cursor I just slap it into the grid.
>>Otherwise, it will be easy to do it in Fox, but I have too many fields to do a SELECT on that.