>Hi,
>If i have expression like this in my where clause, would SQL Server utilize the index?
>
>myCharacterField + Convert(char(10), myDataTimeField, 112)
>
>If not, how would the expression look like in order to make use the index?
>
>Thank you
I don't know if it would do. Why don't you simply do:
myCharacterField = ... and Convert(char(10), myDataTimeField, 112) = ...
Cetin