What is the SQL Server equivalent to Access IIf() function?
Access SQL
IIf([ResultValue]>=1, [Result Value], Null)
SQL Server
CASE WHEN [Result Value]>=1 THEN [Result Value] ELSE NULL END
What is the SQL Server equivalent to Access IIf() function?
IIf([ResultValue]>=1, [Result Value], Null)
CASE WHEN [Result Value]>=1 THEN [Result Value] ELSE NULL END