how can I show row # as the first field

["Stone, Joel" <Joel.Stone@xxxxxxxxxx>]

select row_number() over (),* from client





This doesn't work - any ideas?

thanks

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________