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;
>
>