>hello Fabio
>thank you very much for reply
>the id_no field type is char & size is 12 .
>
>best reagrds
>Mazahir

Then, if ID_NO is a 12 digits fixed length or with a left alignment:

* a index on ID_NO must to exist
INDEX ON ID_NO  TAG ID_NO

SELECT CONTRNO,ID_NO,SUBNO FROM POSTPAID WHERE ID_NO == "271120500557" ORDER BY ID_NO INTO CURSOR QUERY1

With right:

* write ID_NO with PADL(,12)
SELECT CONTRNO,ID_NO,SUBNO FROM POSTPAID WHERE ID_NO == PADL(....,12) ORDER BY ID_NO INTO CURSOR QUERY1