Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Chris Cubley Using Exotic Joins in SQL Part 1 RE: Using Exotic Joins in SQL Part 1

  • May 2, 2005 at 6:15 pm

    #556425

    quote

    BETWEEN is purely simpler to read. There is no specific engine enhancements that make BETWEEN any faster.

     

    2cents more..."Between" is not ANSI 92 standard, so using < and > is more portable.

    Signature is NULL