SQL UDFs enable you to encapsulate regular SQL expressions in functions and then use them like standard SQL functions.
Rather than coding commonly used SQL expressions repeatedly in queries, you can put the SQL expressions in SQL UDFs.
Moving complex SQL expressions from queries to SQL UDFs makes the queries more readable and can reduce the client/server network traffic.