Hello Chris

Please excuse a question from a newbie, but is there an advantage in using the between operator as opposed to using >= and <= comparisons. 

Looking at the execution plans of some of my queries it seems to make no difference to the plan structure or cost of the query replacing >= and <= with between in either the WHERE or from clause, but it certainly makes the syntax a bit neater.

David