Hi Kevin.

SEEK will move the record pointer. With INDEXSEEK, there is a parameter that specifies if you want to move the record pointer. I'm assuming since you are considering an SQL, you don't want the record pointer moved.

>OK
>
>SELECT *;
>FROM Table;
>WHERE Field = MainTable.PKField;
>INTO ARRAY aTemp
>
>IF _TALLY > 0
> RETURN .F.
>ELSE
> RETURN .T.
>ENDIF
>
>The field used in the select will be an indexed field - so is optimized.
>
>If I use the SEEK - I would just
>
>IF SEEK(cValue)
> RETURN .T.
>ELSE
> RETURN .F.
>ENDIF
>
>Kev