Quick Tip: Search for SQL User-defined Functions in 1 Line

SELECT * FROM sys.objects WHERE RIGHT(type_desc, 8) = 'FUNCTION'