Execution error: \'the function name is not a recognized built-in function name\'

SQL Server scalar user defined functions must be called with 2 part names. You need to write as username before function.  So if your function name is "function1" and is defined in the dbo schema, then instead of  "select function1()" you should call it as "select dbo.function1()"  Functions will run like below: select dbo.AVG(columns name) from (table_name) - Returns the average value select dbo.COUNT(columns name) from (table_name) - Returns the number of rows select dbo.FIRST(columns name) from (table_name) - Returns the first value select dbo.LAST(columns name) from (table_name) - Returns the last value select dbo.MAX(columns name) from (table_name) - Returns the largest value select dbo.MIN(columns name) from (table_name) - Returns the smallest value select dbo.SUM(columns name) from (table_name) - Returns the sum