SQL Server does not support index on expressions.
ltDtStart = DTOT(xmydate)
ltDtEnd = DTOT(xmydate+1)
...
WHERE mydate >= ?ltDtStart AND mydate < ?ltDtEnd
...
>
>I will create a datetime field. I'll save date and time to it. I need date and time and have filtering just date part. Should I create an index like;
>
>CONVERT(char(10),mydate,112)
>
>and use;
>vfp:
>xmydate=dtoc(date(),1)
>sql server:
>where convert(char(10),mydate,112)=?xmydate
>
>for performance
>
>or is just an index with mydate is enough for performance;
>
>vfp:
>xmydate=date()
>sql server:
>where mydate=?xmydate
--sb--