>>index on dupkey+codex + Cast(2^31-1- Cast(strtran(COPYNO, chrtran(COPYNO, '0123456789', '')) AS I) AS M) DESCENDING TAG docky
>
>Thanks I will try it
update
index on dupkey+codex + Padr(Cast(2^31-1- Cast(strtran(COPYNO, chrtran(COPYNO, '0123456789', '')) AS I) AS M), 10) DESCENDING TAG docky
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/Never explain, never complain (Queen Elizabeth II)