Home Forums Article Discussions Article Discussions by Author Discuss content posted by Fred Simmons Converting Access Queries with iff() and DLookup() to SQL Server RE: Converting Access Queries with iff() and DLookup() to SQL Server
dgreen-1126628
SSC-Addicted
Points: 447
More actions
March 8, 2010 at 6:36 am
#1129957
Should be TOP 1 for T-SQL, instead of FIRST, I think. First is used in other SQL's, it think, like db2, at the end of the select clause. First does work in Access; I tried it.