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 >
It's "my" world. You're just living in it.