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,980 reads

There's a great article from MIT Technology Review about resetting on the hype of...

etherness – n. the wistful feeling of looking around a gathering of loved ones,...

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Comments posted to this topic are about the item The Microsoft SQL Year in...

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Comments posted to this topic are about the item Your Value from a Conference

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)

SELECT UNISTR('Hello 4E16754C') AS 'A Classic';