>>>>
>>>>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?
It is exactly the same as original Fld1 = @nNumber or Fld2 = @nNumber or ...
So, it is optimizable if we have indexes on each of these columns.
If it's not broken, fix it until it is.
My Blog