We are creating views against a SQL Server and have encountered new thing (go figure). In the SQL server, there is a datetime field and we tried to setup a VFP view to pull just the date portion in the view:

ttoc(subs(record_datetime,1,10)) as JustDate

When we attempt to run the view, we get an ODBC error saying function ttoc not found, if we try just substring() we get a conversion error, but if we do left(record_datetime,1,10) it works returning a character field.

I just thought there may be a posting somewhere that list valid command you can use in a remote view.

Thanks for any help.
Kirk