>Thanks everybody for your answers !!
>
>And for the problem of ENGINEBEHAVIOR, I have made some tests. If I create a table under VFP9 with an index, I have a "full" Rushmore optimization level (with SET ENGINEBEHAVIOR 90). The same table created with a prior version of VFP gives me a "none" Rushmore optimization level. I have to set ENGINEBEHAVIOR to 80.
>A bit strange...
>

LIKE is optimized on VFP9 only.

>>>>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,
>>
>>It's not going to work because spaces you're adding will never match actual letters in the last name.
>>Following will work
>>

>>WHERE LNAME+FNAME LIKE PADR("A", LEN(LNAME), "_")) + "B%"
>>