Skip to content
  • There are no suggestions because the search field is empty.

T-SQL Script: Searched CASE

T-SQL Script: Searched CASE, Each condition is a full Boolean expression — more flexible.

SELECT 
    CASE 
        WHEN Amount > 1000 THEN 'High'
        WHEN Amount BETWEEN 500 AND 1000 THEN 'Medium'
        WHEN Amount < 500 THEN 'Low'
        ELSE 'No Amount'
    END AS AmountCategory
FROM dbo.Payments;