I store a bit in the database and want to return a string "checked" 1

[mit99mh]

I store a bit in the database and want to return a string "checked" if the bit is 1 and nothing / zero length string if the bit value is zero - is it possible to do this?

Any help appreciated

 

[AWithers]

You could use a case statement

select 'status' =
CASE yourbitfield
WHEN 1 THEN 'checked'
ELSE 'not checked'
END
from yourtable

Andy

 

[mit99mh]

thanks that really set me on the right track