>>lcFromTable='x2' >>lcResultTable='crsMyCursor' >>For x=1 to 4 >> lcName=Evaluate('lcName'+Transform(x)) >> If !Empty(lcName) >> Select * from (lcFromTable) where name1=lcName or name2=lcName or name3=lcName or name4=lcName into cursor (lcResultTable) READWRITE >> lcFromTable=lcResultTable >> EndIf >>EndFor>>NB! I tested it this time. :-)
> Select * from (lcFromTable) where (m.lcName1=="" OR (name1=lcName1 or name2=lcName1 or name3=lcName1 or name4=lcName1) ) >AND ((m.lcName2=="" OR (name1=lcName2 or name2=lcName2 or name3=lcName2 or name4=lcName2) ) >AND ... > >>into cursor (lcResultTable)