>Hi,
>
>Thanks for your help!
>
>If I use an index, I think I can gain some more performance by dropping the ORDER BY ... DESC (I suppose it causes an index creation on-the-fly), something like the below:
>
>

>SELECT REFN ;
>    FROM table1 ;
>    WHERE (REFN LIKE (?cTextBeforeCounter)) ;
>    INTO CURSOR table1_
>
>GO BOTTOM IN table1_
>

>
>Do you think the above will be faster?

Maybe a few milliseconds more, I don't know. With index it would be still fast enough you can keep your order by. It does that on the client in either case.
Cetin