Is there a T-SQL function accepting a delimited string of arguments?

[jasonsalas]

Does SQL Server have a built-in function like SUM() or COALESCE() that can accept a delimited string of some sort whwrein I can pass multiple values?

For instance, if I have 60 form elements on a webpage, can I set the form elements to a single comma-delimited string (or other delimiting character) and pass this onto some system function inherent to SQL Server, instead of doing something like this:

INSERT INTO TableName VALUES (val1,val2,val3,val4...valN)

 

[dbomrrsm]

See faq183-3979

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[donutman]

And the improved version of the FAQ:
Passing a list of values to a Stored Procedure (Part II) faq183-5207
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]