Row Number

Is there a way to add a row number to a query?  I want to use the row number as a unique id field.  Is there a function similar to the ROW_NUMBER() that's available?

I have a table named CUSTOMERS with fields titled FirstName and LastName.  I want each row to have a unique number (the first row 1, the second row 2, third row 3, etc.) similar to the table below.  

ID  FirstName  LastName
1    xxxxx      xxxxxx
2    xxxxx      xxxxxx
3    xxxxx      xxxxxx
4    xxxxx      xxxxxx
N    xxxxx      xxxxxx

Thanks,

Joe



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/