>>Hello,
>>
>>I have a table with some fields including LNAME and FNAME (Lastname/Firstname).
>>One index on LNAME+FNAME
>>
>>I want to make several requests :
>>- only lnames beginning with... (SELECT * FROM t1 WHERE LNAME="A")
>>- both lnames and fnames begining with..(SELECT * FROM t1 WHERE LNAME="A" AND FNAME="B")
>>
>
>For your second query, you could use something like:
>
>WHERE LNAME+FNAME = PADR("A", LEN(LNAME)) + "B"
>
>Tamar

Tamar,
VFP can not optimize "f1(field) = f2(field)" for any index is created.