Re: Aggregate functions on Boolean data type

Cast the booelans to integers or chars. J. Kennedy, Randy wrote: > I have used sum(Boolean field) in both Access and SQL Server for years > to get 'counts' of the records that are yes/true. > > I created the same type of query (building a view) in IDS (9.4FC3 on > HP/UX 11.11) and receive a "Routine (plus) can not be resolved." error. > Since Booleans are 0 or 1, I would expect this query to function the > same in IDS. Is this a bug or known issue and has anyone used Booleans > in this manner and have a different approach? > > *Thanks,* > *Randy* > sending to informix-list