| Subject | Re: [ib-support] Count and distinct |
|---|---|
| Author | Lester Caine |
| Post date | 2003-01-15T10:34:54Z |
Jason Chapman (JAC2) wrote:
distinct (x || '!' || y)
where the ! is a 'safe character for your application.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
> Hi Ann,So -
> Row 1:
> x = 'ABC'
> y = 'DEF'
> Row 2:
> x= 'ABCDE'
> y= 'F'
>
> Would break that wouldn't it.
>>select count (distinct (x || y)) from <table>
distinct (x || '!' || y)
where the ! is a 'safe character for your application.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services