From previous postings I have read it seems that I cannot create a
function that accepts a variable list of parameters. Seems that SQL
Server does not support this.
A few questions:
Is this true?
What is a workaround?
Then how does the function COALESCE do it?
Cut and pasted from online books:
Syntax
COALESCE ( expression [ ,...n ] )
Arguments
expression
Is an expression of any type.
n
Is a placeholder indicating that multiple expressions can be
specified. All expressions must be of the same type or must be
implicitly convertible to the same type.