marc, I don't think COUNT (DISTINCT column) works with an expression, only with a column. So make your expression into a column of a view:
CREATE TEMP VIEW marcsview (custbydate) as select (ctxt (custnum) + ctxt(tr_date)) from tab SELECT COUNT (DISTINCT custbydate) FROM marcsview Bill On Thu, 11 Oct 2001 07:57:39 -0500, marc wrote: >What is wrong with this select statement? > >Select Count (Distinct (ctxt(custnum) + ctxt(tr_date)) From tab ... > >I have tried different variations but so far no luck. >
