TSQL to return NO or YES instead TRUE or FALSE

Question

How can I show a different value if some columns return FALSE,

for example,

COLUMN "BASIC" returns FALSE, but I need show for the user YES or NO. Case FALSE, return NO.

Answer 1

If varchar or bit, handling NULLs

case     when BASIC = 'FALSE' then 'NO'     when BASIC <> 'FALSE' then 'YES'     else 'UNDEFINED' end 

or if just bit

case     when BASIC = 1 then 'YES'     when BASIC = 0 then 'NO'     else 'UNDEFINED' end 

Edit:

SELECT      TipoImovel_Id AS TII_SEQ,     Descricao AS TII_DSC,      Sigla AS TII_DSC_SIGLA,     -- choose which one you want from the answers here     case         when BASIC = 1 then 'YES'         when BASIC = 0 then 'NO'         else 'UNDEFINED'     end AS SomeColumnName FROM San_TipoImovel";