SQL Server Logical Functions

This page lists the commonly used logical functions in SQL Server.

  1. CASE

    In SQL Server, the CASE expression can perform branching based on certain conditions and return the corresponding results.

  2. COALESCE

    In SQL Server, the COALESCE() function is used to return the value of the first non-null expression in a list of parameters.

  3. IIF

    In SQL Server, the IIF() function is a conditional function used to return different values based on specific conditions.

  4. NULLIF

    In SQL Server, the NULLIF() function is a conditional function that compares two expressions and returns NULL if they are equal, otherwise it returns the value of the first expression.