Thanks Bill I never thought of that.
marc At 08:36 AM 10/11/2001 -0500, you wrote: >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. > > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
