SELECT * FROM tableName ORDER BY colName
If you want last():
SELECT * FROM tableName ORDER BY colName DESC
You need to order the result set because SQL server has no concept of First and Last.
By definition, a table is an unordered set of rows.
"Greg" <GMaceclaimline.com> a écrit dans le message de news: 03ce01c340d2$a049d950$a301280aphx.gbl...> We are in the process of converting our Access 97
> Database to SQL 2000. We will be using a Access 2002
> front end. We are in the process of rewriting our DAO
> code to ADO. I am sure this has been asked a thousand
> times, but how can you create a User defined function to
> do the equivalent of the First() function ?