Posted by Edgar on 05/18/06 20:26

Hi,

I have a varchar column with values like:

000 BNP=Item one HOP=Item two LLT=Item three
001 LLT=Item one
002 BNP=Item one LLT=Item two

I want to parse this rows into a table similar to the following output:

000 BNP=Item one
000 HOP=Item two
000 LLT=ItemThree
001 LLT=Item one
002 BNP=Item one
002 LLT=Item two

Has anybody done a similar assignment? Can you share me your solution?

Thank you much!

Edgar J.

• Next in forum: Re: Parsing a varchar(79) column
• Prev in forum: Re: Convert Access Query to SQL Server View
• Thread view: Parsing a varchar(79) column

[Reply to this message]