At 15:08 -0600 2/8/02, José Angel Blanco Linares wrote:
>Hi, everybody
>
>How can I get a numeric column from a SQL SELECT statement?
>I mean, with a SELECT get something like this
>
>ColNum or ColNum
> 1 10
> 2 11
> 3 12
> 4 13
> 5 14
> 6 15
> ... ...
>
>Some time ago, somebody wrote a sample that do exactly what I need. In fact, I
>took that sample and saved it to my HD, but i can't find it, hehehe.
Do you mean you want to number the output rows from a query?
Do you mean you want to specify a beginning and ending number and
generate a series containing all the numbers from the beginning to the
end?
Or something else?
>
>TIA
>
>______________________________________
>José Angel Blanco Linares
>Depto Servicios de Apoyo Académico
>Centro de Enseñanza Técnica Industrial
>3641-3250, ext: 266