"Jason Chapman (JAC2)" wrote:

>
> Hi Ann,
> Row 1:
> x = 'ABC'
> y = 'DEF'
> Row 2:
> x= 'ABCDE'
> y= 'F'
>
> Would break that wouldn't it.
>

A suggestion I was given:

select count(*) from <table>
group by x,y,z

Does this work?
--
Raymond Kennington
Programming Solutions
W2W Team B