true/false to Yes/no SQL

[moley]

I running asp forms from sql database. All the columns which are bit (input from check boxes) are displaying true/ false. Is there a simple way to display the data in yes/no format in text box??

cheers

moley

 

[cfk]

for 0/1 in any queries use
CAST(bitvalues AS INTEGER) AS bitvalue

as far as yes no goes i'm afraid its replace replace
REPLACE(REPLACE(bitvalue,true,"yes&quot,false,"no&quot

pain.

 

[cbokowski]

for asp..
we wrote this function since vbscript doesnt have iif.

function iif(i_Expr, i_True, i_False)
if i_Expr then
iif = i_True
else
iif = i_False
end if
end function


ex:
sText = iif(bModel = True, "Yes", "No&quot