Replace BIT values with some text
Posted
by nihi_l_ist
on Stack Overflow
See other posts from Stack Overflow
or by nihi_l_ist
Published on 2010-06-08T07:47:30Z
Indexed on
2010/06/08
7:52 UTC
Read the original article
Hit count: 144
I have a BIT column with gender (0,1) and want to replace 0 and 1 in the resulting view with the words "man" and "woman". Can i do this right in the view with some system finction or i have to write my own function to do that?
© Stack Overflow or respective owner