Why would you use stored functions?
for formulas and business rules that you want to apply to columns in an SQL query
to automatically modify the data of a table based on a query
for formulas and business rules that should be applied on a specific trigger event like on inserts
for reusing recurring queries