Select a string comparison as a boolean in tsql

Question

In a tsql query, I want to have a calculated field that is the boolean result of a string comparison.

It would look something like this:

select name, (status = 'current') as IsValid
from items

But the query as I have listed is not valid. What is the correct syntax?

Answer 1

I would use a case statement

Select name, case when status = 'current' then 1 else 0 end as IsValid
from items

Answer 2

Try this -

select name, 
(CASE status WHEN 'current' THEN 1 Else 0 END) as IsValid 
from items