User Defined SQL Function Inside Selection

Question

I have a custom function in SQL called getBuisnessDays, it takes @startdate and @enddate and returns the number of working days between two dates. How can I call this function inside my choice?

Here is what I would like to do.

SELECT getBusinessDays(a.opendate,a.closedate) FROM account a WHERE ... 

Answer 1

Yes, you can do almost this:

 SELECT dbo.GetBusinessDays(a.opendate,a.closedate) as BusinessDays FROM account a WHERE... 

Answer 2

If this is a table-value function (returns a table) you simply join it as a table

this function generates one column table with all the values ​​from a comma-supplied list

 SELECT * FROM dbo.udf_generate_inlist_to_table('1,2,3,4') 

Answer 3

Use a scalar-valued UDF, not a table value, then you can use it in SELECT as you wish.