Equivalent T-Sql command to Access First()

[stnkyminky]

I'm moving queries from Access to Sql server and one of them uses the First() command in the query. I can't seem to find an equivalent in T-Sql. Can someone help out?

Thanks

Scott
Programmer Analyst
<{{><

 

[vongrunt]

TOP 1 and subquery.

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.

 

[JamesLean]

As data is not stored in any logical order, First does not have any real value (which is why it doesn't exist). If you're using First currently I'm assuming you just want any row, in which case you can use MAX/MIN.

--James