Re: Getting comma separated values in a column

Tech-Archive recommends: Fix windows errors by optimizing your registry

msnews.microsoft.com
Date: 09/08/04 

Date: Wed, 8 Sep 2004 07:36:52 -0400

Thanks for the replies, everyone.

All the solutions sem to work fine, however, I can't seem to impliment them
into what I need to do. The following is a layout of what my table
currently looks like (tab separated)....

custno additcustnos orderid
123 874,521,625 15
541 53
852 846 12

>From that, what I need to do is produce a temp table that would look like
this....

custno orderid
123 15
874 15
521 15
625 15
541 53
852 12
846 12

It would also be nice to know how many additcustnos where is the column.
Anyways, I really appreciate all the help. Thanks a lot.

Ja

"Jake" <Jake@discussions.microsoft.com> wrote in message
news:E39D1DFC-F04C-45BB-BACE-7385038A02D6@microsoft.com...
> In col1 I have the following value...
>
> 123,abc,rew,blah,uuu45678,h,3342
>
> I need to create a query that will return individual values like so...
>
> 123
> Abc
> Rew
> Blah
> Uuu45678
> H
> 3342
>
> How can this be accomplished without a great deal of programming?
>
> Thanks a lot.
>
> Jake.
>