Abe wrote: > > Hey there, > > Just tried that - No luck - I am using version 6.5.0 - Maybe its just not > available in this version. > Any alternatives ? I have tried this on version 7.02. I assume 6.5 did not support it. > > 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 > > -- http://www.mohawksoft.com