>LIKE clause is NOT rushmore optimizable (till VFP 9 if I remember corectly). Also If You want this clause to be optimazable the must change the WHERE condition to match the index. Can You post how the table is indexed?

Borislav

IF .NOT. EMPTY(consig) && If this variable contains Company name
consig = upper(TRIM(consig))
cWhere = cWhere + IIF(lAnd," AND ","") + "upper(trim(globalnew.Company)) LIKE '%"+consig+"%'" && Add ' before first & after second %
lAnd = .t.
ENDIF

Index is upper(trim(company))

Thanks

Colin