Hello Tore, It's for MSSQL, I just want to return the CONVERTed values, don't want to change the actual data.
Cheers, Nick :> -----Original Message----- :> 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>, ... :> --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
