CONTAINS - Query language in Cosmos DB (in Azure and Fabric)

The CONTAINS function returns a boolean indicating whether the first string expression contains the second string expression.

Syntax

CONTAINS(<string_expr_1>, <string_expr_2> [, <bool_expr>])

Arguments

	Description
string_expr_1	The first string to search.
string_expr_2	The second string to find.
bool_expr	Optional boolean value for ignoring case. When set to true, CONTAINS performs a case-insensitive search. When unspecified, this value defaults to false.

Return types

Returns a boolean expression.

Examples

This section contains examples of how to use this query language construct.

Contains string examples

In this example, the CONTAINS function is used to check for substrings in a string.

SELECT VALUE {
  containsPrefix: CONTAINS("AdventureWorks", "Adventure"), 
  containsSuffix: CONTAINS("AdventureWorks", "Works"),
  containsWrongCase: CONTAINS("AdventureWorks", "adventure"), 
  containsWrongCaseValidateCase: CONTAINS("AdventureWorks", "adventure", false), 
  containsWrongCaseIgnoreCase: CONTAINS("AdventureWorks", "works", true),
  containsMismatch: CONTAINS("AdventureWorks", "Contoso")
}

[
  {
    "containsPrefix": true,
    "containsSuffix": true,
    "containsWrongCase": false,
    "containsWrongCaseValidateCase": false,
    "containsWrongCaseIgnoreCase": true,
    "containsMismatch": false
  }
]

Remarks

• This function performs a full scan.