Searching for text using SQL scalar search functions

Using examples, this section describes how to use the SQL scalar search functions in the following ways:

Refer to SQL scalar search function and the SQL table-valued function for a description of the syntax.