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
say

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

Vahan




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