Re: COMMON FIELDS

On Fri, 19 Apr 2002, allanmartin_at_ntlworld.com wrote:
> Hi,
> Can anyone advise the best way to pull a common string (if any)
> from a feild in a table. They will be grouped by another field.
> I plan to append results to a table.
> e.g.
>
> INPUT TABLE
>
> PK GROUP
> M100A M
> M100B M
> M100C M
> ABCD1 A
> ABCD2 A
> ABCD3 A
> BG456 H
> AFCG H
> ACFE H
>
>
> OUTPUT TABLE
> COMMON STRING GROUP
> M100 M
> ABCD A
> **NONE** H
Does the uniqueness get defined by losing the last character in the PK field?

For example, would the following set of data also return the same result?

M100XA	   M
M100YB	   M
M100ZC	   M
ABCD1T	   A
ABCD2	   A
ABCD3	   A
BG456	   H
AFCG	   H
ACFE	   H

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.