MS SQL Server iff function vs 'case when' This is an off-site link.  Please review our Terms of Service for additional information.

In SQL server, people sometimes use iff function, which is also an Excel function, to assign different values based on a condition. For example, the following query returns 1 if the amt is less than 50, and 0 otherwise.

Read this article...

comments powered by Disqus