>Hi,
>
>What it the replacement of TTOD() when passing SQL Select expression from VFP to SQL Server? For example, if you need the following expression:
>
>

>select * from mytable where TTOD(myDateTimeCol) > '2001-01-01' and TTOD(myDateTimeCol) < '2011-10-10'
>

>
>TIA.

In SQL Server 2008 you can use CAST(myDateTimeCol to DATE)

Otherwise simply use

MyDateTimeCol > '20100101' and MyDateTimeCol < '20111010'