Bosconian wrote:
> "Philipp Tölke" <ascii158@web.de> wrote in message
> news:eg38ql$pqt$1@online.de...
>
>>Bosconian <nobody@nowhere.com> schrieb:
>>
>>>I'm looking the latter, a count of distinct items.
>>
>>The Syntax is COUNT(DISTINCT foo)
>>
>>Cheers
>>--
>>Philipp Tölke
>>PGP: 0x96A1FE7A
>
>
> It's amazing what a difference moving one parenthesis makes. :-)
>
> Many thanks.
>
>

Yes, you were getting a distinct count - hence my question (trying to
steer you onto the right course).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================