>hi Serge,
> for me to be able to return it as table, creating temporary table and insert it during the loop. the query the temp after the loop. do u have any better idea?

I'm not sure what you're trying to do but a table variable may be better in this case. Or maybe it's better to do split on the client side. Can you provide more details?