FETCH and MOVE

Hello,

In a table indexed by name, I created a cursor like this :

BEGIN TRANSACTION;

DECLARE cursor1 FOR SELECT NAME FROM AUTHORS ORDER BY NAME;

What should I do when I want to move to author wich name is John ?

Are there anyway to Move with Strings ?

I don't know how much I need to move the cursor to John.

Are there any function that show me how much I need to move the cursor to John ?

Can anybody help me ?

Thanks.

Waldomiro C Neto.
Shx Informática Ltda.
+55 (11) 5581-1551
www.shx.com.br
wmiro(at)shx(dot)com(dot)br