The trick here is to set the decimals correctly so the output is formatted as you expect. Here is the code:

LOCAL lCurrentDec
lCurrentDec=SET("Decimals")
SET DECIMALS TO 0
SELECT name,PADL(MIN(VAL(item)),5,"0") as "Start", ;
PADL(MAX(VAL(item)),5,"0") as "End" ;
FROM MyTable ;
GROUP BY name ;
into CURSOR curMyTable
SET DECIMALS TO &lCurrentDec

>Hello all
>
>I have the data in following order
>
>Name Item
>---- ----
>
>Admin 00001
>Admin 00003
>Admin 10004
>Admin 10040
>EDP 10000
>EDP 10002
>EDP 10005
>Admin 21222
>Admin 23233
>Admin 32334
>
>How to get the result in this order
>
>Name Start End
>-----------------------------
>Admin 00001 10040
>EDP 10000 10005
>Admin 21222 32334
>
>Txs