Splitting the string

Question

Hi there,

I have a string which i'm passing to the Stored Procedure,

say like this  abc,123,xyz@abc,123,xyz@abc,123,xyz

Now i need to insert abc, 123 and xyz as one record in a table.

Here I think I have to separate each values per record splitting it with @. How can I achieve it.

Regards,

MZEE.