Adding auto-increment / sequence

Hey all,
Is there any way to add some kind of sequence of auto-incrementing
column to the result set returned by a  SELECT?

I need to get an auto incrementing column of some kind into the result
set from a view?

Thanks in advance,
Cam