How to show a 1 or 0 in select statement

Transact-SQL
2

hi

one thing you can do is ..use case statement
case when leftjoincolumn is null then 0 else 1 end

hope it helps
:slight_smile:
:slight_smile:

1 Like