Nick, Try using single quotes instead of double quotes and see if that works :-)
--Ben ----- Original Message ----- From: "Nick Middleweek" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 7:30 AM Subject: RE: Converting boolean or int columns to strings? > I've got this in my Query Analyser... > > > 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 LOH_Buildings > > > but I get an error... > > Server: Msg 207, Level 16, State 3, Line 1 > Invalid column name 'Sat'. > Server: Msg 207, Level 16, State 1, Line 1 > Invalid column name ' '. > Server: Msg 207, Level 16, State 1, Line 1 > Invalid column name 'Sun'. > Server: Msg 207, Level 16, State 1, Line 1 > Invalid column name ' '. > > > What am I doing wrong? > > 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]
