Hi Sergey,

SET ANSI ON apparently does not affect the result. Here's the code I'm trying:

CREATE CURSOR c_Test;
(iSaleid i,;
cInvoiceNo c(11),;
cDesc C(10))

FOR i = 1 TO 11
	INSERT INTO c_Test (iSaleid, cInvoiceNo, cDesc) VALUES (i, TRANSFORM(i), TRANSFORM(i))
ENDFOR

SET ANSI ON

SELECT c_Test.*;
	FROM c_Test ;
	WHERE iSaleid in (SELECT TOP 2 isaleid FROM c_Test ORDER BY cInvoiceNo desc)

SET ANSI OFF

SELECT c_Test.*;
	FROM c_Test ;
	WHERE iSaleid in (SELECT TOP 2 isaleid FROM c_Test ORDER BY cInvoiceNo desc)

my result has 8 and 9, not 10 and 11.



>Check String comparison in VFP
>

>SET ANSI ON
>SELECT Sales.* ;
>   FROM Sales ;
>   WHERE iSaleID IN (SELECT TOP 2 iSaleid FROM Sales ORDER BY cInvoiceNo DESC)
>

>
>>
>>I have a query like this:
>>
>>

SELECT Sales.* ;
>>   FROM Sales ;
>>   WHERE iSaleID IN (SELECT TOP 2 iSaleid FROM Sales ORDER BY cInvoiceNo DESC)

>>
>>The problem I'm having is due to the fact that if I have invoices entered with cInvoiceNo from "1" to "11", I want Invoices "10" and "11" to be returned, but I'm getting Invoices "1" and "11". So I really want to do something like this:
>>
>>

SELECT Sales.* ;
>>   FROM Sales ;
>>   WHERE iSaleID IN (SELECT TOP 2 iSaleid FROM Sales ORDER BY PADL(cInvoiceNo, 11) DESC)

>>
>>but of course that gives me a syntax error.
>>
>>Any ideas what I can do? I have no control over the invoice numbers as they are being returned from QuickBooks.
>>
>>Thanks,