Thanks David to both of those, I'm sure | is quicker than CAST ing and adding them together as I've done so I'll change it.
Cheers, Nick :> -----Original Message----- :> From: David L. Penton [mailto:[EMAIL PROTECTED]] :> Sent: 29 August 2002 14:20 :> To: ActiveServerPages :> Subject: RE: Converting boolean or int columns to strings? :> :> :> SELECT :> "PK_ID", :> "Name", :> "Borough", :> CASE ("Sat_Std" | "Sat_Other") :> WHEN 1 THEN 'Sat' Else '' END as "Open_Sat", :> CASE ("Sun_Std" | "Sun_Other") :> WHEN 1 THEN 'Sun' Else '' END as "Open_Sun", :> "Postcode" :> :> FROM "dbo"."LOH_Buildings" :> :> :> David L. Penton, Microsoft MVP :> JCPenney Application Specialist / Lead :> "Mathematics is music for the mind, and Music is Mathematics for the :> Soul. - J.S. Bach" :> [EMAIL PROTECTED] :> :> Do you have the VBScript Docs or SQL BOL installed? If not, why not? :> VBScript Docs: http://www.davidpenton.com/vbscript :> SQL BOL: http://www.davidpenton.com/sqlbol :> :> :> -----Original Message----- :> From: Nick Middleweek [mailto:[EMAIL PROTECTED]] :> :> 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]
