Hi Ann,
Row 1:
x = 'ABC'
y = 'DEF'
Row 2:
x= 'ABCDE'
y= 'F'

Would break that wouldn't it.

JAC

""Ann W. Harrison"" <aharrison@...> wrote in message
news:5.1.0.14.2.20030113114511.02bfaec0@......

> At 03:24 PM 1/13/2003 +0200, Gerhardus Geldenhuis wrote:
> >Hi
> >I have done a count(distinct(x)) with great success. The problem is now
> >that I want to do a count(distinct(x,y)). It does not work at all.
>
> Try
> select count (distinct (x || y)) from <table>
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>