Hi.

How would you do something like this?:

SELECT COUNT(DISTINCT uid) AS count FROM table;

Hi John,

Select Distinct UID
Into "\memory\temp"
from Table;
Select Count(*) as NumRecs
from "\memory\temp";

Then drop temp table ...
PS Try avoiding reserved words for renamed columns (ie Count)

hth.  Donat.

"John" <eydunl@post.olivant.fo> wrote in message
news:42CB94F2-7133-4248-9ED1-DBE01DFFE48C@news.elevatesoft.com...
> Hi.
>
> How would you do something like this?:
>
> SELECT COUNT(DISTINCT uid) AS count FROM table;
>
>