Re: [SQL] Split String Into Multiple Records

2007-04-21 Thread Aaron Bono
On 4/21/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Aaron Bono" <[EMAIL PROTECTED]> writes: > Is there a good way to split a string into multiple records? > I have a table "branch" with a column "branch_num" which has a comma > delimited list of numbers - the users weren't supposed to do this but

Re: [SQL] Split String Into Multiple Records

2007-04-21 Thread Tom Lane
"Aaron Bono" <[EMAIL PROTECTED]> writes: > Is there a good way to split a string into multiple records? > I have a table "branch" with a column "branch_num" which has a comma > delimited list of numbers - the users weren't supposed to do this but they > did and now I have to fix it. We want to cr

[SQL] Split String Into Multiple Records

2007-04-21 Thread Aaron Bono
Is there a good way to split a string into multiple records? Here is what I am trying to do... I have a table "branch" with a column "branch_num" which has a comma delimited list of numbers - the users weren't supposed to do this but they did and now I have to fix it. We want to create a new ta