Fred Simmons

Converting Access Queries with iff() and DLookup() to SQL Server

This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(38)

You rated this post out of 5. Change rating

2010-03-08

10,978 reads

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...

In the United States, today is Thanksgiving. The intent behind the holiday is to...

Comments posted to this topic are about the item FinOps - the new name...

Comments posted to this topic are about the item Which Object Definitions Are Available?

Comments posted to this topic are about the item What's Your Theme Music?

For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)