thank you...
>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