Yes, you're right. It would.
Thanks.
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:uy9fjqk3a.fsf_at_rcn.com...
> 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.
Received on Tue Apr 23 2002 - 04:06:08 CDT
