CONTAINS (Transact-SQL) [!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] Searches for precise or fuzzy (less precise) matches to single words and phrases, words within a certain ...

Using the contains () XQuery function to search for a specific character string The following query finds products that contain the word Aerodynamic in the summary descriptions.