Last post Jan 06, 2010 11:51 AM by haggis999
Jan 06, 2010 09:23 AM|haggis999|LINK
In MS Access I can write a query like this (where ClassA, ClassB, etc, are boolean fields):
SELECT [ClassA] Or [ClassB] Or [ClassF] AS HasPrints, EntrySummary.EntrantID, EntrySummary.CompID, EntrySummary.ClassA, EntrySummary.ClassB, EntrySummary.ClassC, EntrySummary.ClassD, EntrySummary.ClassE, EntrySummary.ClassF
However that method of deriving a calculated HasPrints value is not acceptable in ASP.NET. How can I rewrite my query in a standard SQL query format?
Jan 06, 2010 10:26 AM|Steelymar|LINK
in MS SQL you can use:
SELECT [ClassA] | [ClassB] | [ClassF] AS HasPrints,
Jan 06, 2010 11:51 AM|haggis999|LINK
Thanks for that solution. Do you know why something as obscure as the vertical bar symbol is used instead of the more inituitive OR as in Access?