Internally it is essentially the same. Do what makes sense for your
situation and or preference. Some people find BETWEEN easier to read and
some do not.
Andrew J. Kelly
SQL Server MVP
"Susanth Sivaram" <susanthshotmail.com> wrote in message
> I have to retrieve the record between 2 dates. Is it better, if we> date between 'somedate' and 'otherdate'
> date >= 'somedate' and date <= 'otherdate'
> Which is faster?