Yup that's exactly what I want but I'm trying to avoid stored
procedure and generator though...

Thanks anyway!

e:Lita

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:
>
> --- In firebird-support@yahoogroups.com, "elitalaw" <elitalaw@y...>
wrote:
> >
> > Hi All,
> >
> > I would like to obtain running number in my results such as
> >
> > 1, A
> > 2, B
> > 3, C
> > .
> > .
> > .
> > 26, Z
> >
>
> Do you mean you want to create a field that starts at 1 for the first
> record, 2 for the second etc?
>
> If so, you can use a selectable stored procedure to do this.
>
> Adam
>