Help with SQL and combining boolean fields with OR

[Nick Middleweek]

Hello,

I've got this SQL statement (that doesn't work)

SELECT PK_ID,
        Name,
        Borough,
        (Sat_Std OR Sat_Other) as 'Open_Sat',
        (Sun_Std OR Sun_Other) as 'Open_Sun',
        Postcode

FROM LOH_Buildings


I've got two fields that represent both Sat and Sun.

I want to return one column that indicates whether either or both fields are
True.

Can I do this?


Thanks,
Nick


---
You are currently subscribed to activeserverpages as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]