>Is there any way I can have the inedx tags defined on a table added to the cursor created with a select SQL statement.
>
>eg. Select * from Mytable where fieldA='123' into cursor MyCursor
>
>if fieldA is indexed, can I make the fieldA in MyCursor indexed too?
>
>Thanks.
>
>Ria

You can create an index on the field as Sergey and Yury suggest.

But you can also add the "ORDER BY" clause to your select to order the result.

BTW, with your restrictive "WHERE" clause, there is no need to index on this field, all values will be the same (except if fieldA was larger than 3 chars of course) :-)