>>>>>>select * from myTable where nNumber IN (Fld1, Fld2, Fld3). >>>>>>>>>>>>
>CREATE CURSOR crsTest (Fld1 I, Fld2 I) >FOR lnFor = 1 TO 20 > INSERT INTO crsTest VALUES(lnFor,20-lnfor) >NEXT >INDEX ON Fld1 TAG Fld1 >INDEX ON Fld2 TAG Fld2 >lnNumber = 12 > >SYS(3054,12,[tst]) >SELECT * FROM crsTest WHERE m.lnNumber IN(Fld1, Fld2) >MESSAGEBOX(tst) > >SELECT * FROM crsTest WHERE Fld1 = m.lnNumber OR Fld2 = m.lnNumber > >MESSAGEBOX(tst) >SYS(3054,0) >In SQL Server I am getting a table scan in both cases. Perhaps because I need to create a clustered index first.