Replacement DFIRST for SQL

J

John Cosmas

Anyone know how to replace the DFIRST statement in Access to working in/with
SQL. SQL Server does not have an equavalent statement/function.

John Cosmas
 
D

Duane Hookom

You could use a subquery:
(SELECT TOP 1 YourField FROM tblYourTable ORDER BY OtherField)
 
Top