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 PROTECTED]
