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 CFCFconcat_3 3 CFCFCFconcat_4 4 CFCFCFCF