How to Convert Varchar(1) to Bit in Sql Query?

Question

I want to convert a varchar(1) to bit (True or False) or (0,1).

For example if varchar(1) value is 'N' means it should be convert to '1' else it should be convert to '0'.

Is it possible in SQL?

N=>1 is an unusual mapping. Is that really what you're looking for? (Most people would interpret N as "No", which generally maps to a false value) — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Sep 24, 2013 at 7:28

juergen d · Accepted Answer · 2013-09-24 07:26:37Z

1

Use a case

select case when your_varchar_column = 'N' 
            then 1 
            else 0 
       end as your_bool_result
from your_table

Depending on your SQL engine you could also use an if statement if available.

answered Sep 24, 2013 at 7:26

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

1 Comment

Thanks juergen d, it is helpful for me.