Hey there, Just tried that - No luck - I am using version 6.5.0 - Maybe its just not available in this version. Any alternatives ? Thanks Guys, Abe ----- Original Message ----- From: "mlw" <[EMAIL PROTECTED]> To: "Abe" <[EMAIL PROTECTED]>; "Hackers List" <[EMAIL PROTECTED]> Sent: Monday, December 25, 2000 11:23 PM Subject: Re: COUNT(Distinct city) HELP!!! > Abe wrote: > > > > Part 1.1 Type: Plain Text (text/plain) > > Encoding: quoted-printable > > Try this: > select count(distinct (city) ) from ct > -- > http://www.mohawksoft.com >
