The following SELECT statement displays information about the overloaded functions named 'concat' in 'dba' database:
SELECT SpecificName, NumParameters, ParameterDataTypes FROM FunctionsV WHERE DatabaseName = 'dba' AND FunctionName = 'concat' ORDER BY 1,2,3;
Result:
SpecificName NumParameters ParameterDataType ------------- ------------- ----------------- concat 2 CFCF concat_3 3 CFCFCF concat_4 4 CFCFCFCF