No, there is no way to do what you want.
If you only want to go to John, why not add the where clause?
Dave
On Wed, 2003-08-20 at 08:18, Waldomiro wrote:
> 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@shx.com.br
--
Dave Cramer <Dave@micro-automation.net>