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