Case Sensitivity

The Google Ads Query Language lets you filter the returned data set with a number of different operators. When filtering on string values, the default case sensitivity of each operator will play an important part in correctly filtering your results.

Operators	Case Sensitivity
= or !=	Case sensitive
(NOT) IN	Case sensitive
(NOT) LIKE	Case insensitive
CONTAINS (...)	Case sensitive
REGEXP_MATCH	Optionally Both

Key Point: REGEXP_MATCH and NOT REGEXP_MATCH are case sensitive by default, but you can include (?i) to make them case insensitive. Example:

SELECT campaign.id
FROM campaign
WHERE campaign.name REGEXP_MATCH "(?i).*test.*"