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