For an example of a search function in a search expression, see Relational query syntax introduction.
You create a search function with a search function definition, which references the implemented search function handler. The name of the search function is specified in the search function handler in the following format: name-space::short-name. This same name must be used in the search expression to reference the search function. The name of a search function and the name of the search function definition for that function can be different.
You cannot use custom search functions in a stored search.
You can use these functions in ad hoc or background searches in a
SELECT list only.
To create a search function definition: