Skip to Content
0
Former Member
May 09, 2008 at 09:43 PM

how to split a table fields and create a new record for each split

287 Views

Hi,

Could any one let me know how to split a table with strucutre and create a new record for each split. structure is as follow:

Filed1

Filed2

Filed3 more than one value seperated wtih commas

I need to split Filed3 values and create a new record for each split. Split is on comma operator.

Thanks

Rajeev.