No, it's MS SQL Server <g>

>Right, but my point is it's still PITA :)
>
>>>Thanks to both you and Sylvain. You guys both responded with just about the same way to do this (convert bit to int) so I guess it's how it's done.
>>>
>>>Just one more thing: I purposesly made the SELECT short but if I have a lot fields in the Invoice table that I need to retrieve, this means I have to specify every fields I need instead of doing "SELECT A.*..." which would be PITA.
>>
>>No you don't have to list them in the Select field list but you'll have to in the GROUP BY clause.
>>
>>< SNIP >