>>>>

>>>>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.