Hi Gang 

I have a table with several columns.


I want to determine a count of unique records based on column 1.

I thought this would work but alas....
= SELECT COUNT (DISTINCT TABLE.COL1 from TABLE