What database? Do you want to permanently change it, or just return the
alternative value?
SQL Server:
Select Case colBit
When 0 Then ""
Else "Sat"
End as <Alias>, ...
MS Access:
Select IIF(colBit = 0, "", "Sat") as <Alias>, ...
HTH,
Tore.
-----Original Message-----
From: Nick Middleweek [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 9:09 AM
To: ActiveServerPages
Subject: Converting boolean or int columns to strings?
Hello,
Is there a way of converting a bit or int column from 1 and 0 into "Sat" and
"". This way I don't need to do the checks in ASP, I can can then just write
the column value.
Thanks,
Nick
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
