>>>
>>>select * from myTable where nNumber IN (Fld1, Fld2, Fld3).
>>>
>>>
>>>They will behave the same as your original code, just a shorter code.
>>>
>>>There is no faster approach for this problem.
>>
>>Thank you.
>
>You're welcome.
Is it optimizable?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.