SyntaxFix
Write A Post
Hire A Developer
Questions
The query can be written slightly simpler, like this:
DECLARE @T INT = 2 SELECT CASE WHEN @T < 1 THEN 'less than one' WHEN @T = 1 THEN 'one' ELSE 'greater than one' END T