Subject usage of = and between in queries
Author Vahan Yoghoudjian
Hello all

First of all I want to wish you all the best for the new year....

Is there any differences in the usage of indexes if in the query if I

Method1: where (CODE = 'ABCD')
Method2: where (CODE between 'ABCD' and 'ABCD')

The main reason for this is that I have functions that write conditions
of some queries at run time according to the selected values from two Lookup
combos by the user (FROM and TO). So far in these functions I am not
checking if those two values are equal, whatever the values are (of course
only if TO >= FROM) the second method is used to write the condition...
If in thise case the first method has better performance I will adjust
the functions in order to generate this method if both values are equal

Thank you in advance


[Non-text portions of this message have been removed]