I believe you're looking for the row_number function. (Thanks to Terry Purcell for making me aware of this)
Here's an example: select id,name , row_number( ) over () from staff David Seibert Compuware Corporation File-AID Product Architect [EMAIL PROTECTED] ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
