[SQL] Cursor

[Xavier Bermeo]

hi guys...........

This my cursor

DECLARE
var varchar(15);
  cursor1 CURSOR FOR select codigo_uni as codigo
            from recorrido
            where estado='V';

BEGIN
 open cursor1;

var=cursor1.codigo;
END;

It's almost 200 records,
but, I not unknow how read  record for record, I need found one record
specific,

Excuse me  my english, no write nothing goog, I'm from ecuador.

Or explain how, I use the loop, while,  in my function declarated.
Please, more guides....

Thanks................