I want to test some evaluations without working on any table. For example, you can write
SELECT 1+1 >2
I want to achieve something like this:
SELECT 2 > 1 >FALSE
I know that most engines don’t have the concept of a boolean data type, but I don’t know how their internal work (even if I guess everything <> 0 is true
, like in C). Anyway, the format of the response really doesn’t matter, whether it’s true/false
or 0/1
Advertisement
Answer
SELECT CASE WHEN 2 > 1 THEN 'True' ELSE 'False' END