Search a function

To populate all User-Defined functions in the current database we can use the query

SELECT *
FROM sys.objects
WHERE type IN ('FN', 'IF', 'TF')

To search specific User-Defined function by name we can use

SELECT *
FROM sys.objects
WHERE type IN ('FN', 'IF', 'TF') and name LIKE '%zero%'