>>Don't worry. Using BETWEEN, SQL server doesn't have a problem with datetime values and it doesn't have a problem with the time portion either. It is VFP that does have a problem with time portion.
>>Cetin
>
>Why do you say that? Please read carefully Aaron Bertrand's blog I gave in my other message.
Because it is like that. I wouldn't read, it is a long writing. Would you instead tell me where does it say SQL server has problem using between with datetime values or it has a problem with the time portion.
Cetin