replacement for DFirst() function in SQL

[AlAsh]

i am translating and access application to SQL application and i need to know what you use instead of Dfirst function


thanks

[NeoPa]

I don't believe there is a direct equivalent. You would probably use a subquery instead.

[ck9663]

Not that I know of, Neo. Subquery or CTE is probably the efficient solution for this.

~~ CK

[NeoPa]

Quite right CK. I should have mentioned the CTE, or Common Table Expression, facility introduced in SQL 2005. It can make for much tidier, more readable and more efficient code.