On Feb 3, 2:19 pm, "--CELKO--" <jcelko...@earthlink.net> wrote:
> >> I have a unique situation. <<
>
> Probably not!! Trust me!
>
> >> My data looks something like: <<
>
> Please post DDL, so that people do not have to guess what the keys,
> constraints, Declarative Referential Integrity, data types, etc. in
> your schema are. Sample data is also a good idea, along with clear
> specifications. It is very hard to debug code when you do not let us
> see it.

Thanks Erland, your solution did it. I don't understand how the
second part of the syntax: SELECT DISTINCT 'Metals'
FROM MYSAMPLES

shows up as 'METALS'. I thought i would have had to select an AS
somewhere...nonetheless it worked!!