SQL Conditional on Bit

Question

Why does this..

DECLARE @SkyBlue Bit
SET @SkyBlue = 1
IF @SkyBlue
    Select 'the sky is blue!'
ELSE
    Select 'the sky is not blue!'

Produce this

"An expression of non-boolean type specified in a context where a condition is expected, near 'Select'."

And is there a Boolean type in SQL2008?

Matthew Vines · Accepted Answer · 2009-09-09 15:26:06Z

13

@SkyBlue is a bit, not a boolean. Try:

DECLARE @SkyBlue Bit
SET @SkyBlue = 1
IF @SkyBlue = 1
    Select 'the sky is blue!'
ELSE
    Select 'the sky is not blue!'

Note that this also fails

if 1
    Select 'the sky is blue!'
ELSE
    Select 'the sky is not blue!'

answered Sep 9, 2009 at 15:26

Matthew Vines

27.7k7 gold badges80 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1