>>Hi,
>>Thank you. May I know how to compare date only portion in SQL?
>>I know we can use CONVERT() but would it be optimized since index cant contain function (could it?). ?
>>
>>Thank you
>
>
>... DATEDIFF(day,datetime1,datetime2)=0
>
Yes, that's what I meant. Is it the same as comparing datetime field with 2 parameters in terms of optimization?
If it's not broken, fix it until it is.
My Blog