>Can you reference a function from another function? In this case the system has default labor rates based on the type of labor for each entry. There can also be rates specific to each job. If there are not job specific rates then the system defaults are used. I think I also need to create a function to return the correct rate.
>
>TIA
>Jeff

You can call some system defined functions. You can call UDF from UDF.

Here is a quick test:

-- Test query
create function fn1()
returns int
as
begin
       return 1
end
GO
create function fn2()
returns int
as
begin
       return dbo.fn1() * 2
end
GO
print dbo.fn2()
drop function fn2
drop function fn1

Thanks to my friend I consulted quickly with.