>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'
If it's not broken, fix it until it is.
My Blog