Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
    • Neuroanalyst for creating calculated fields
      • All Functions
        • Overview
        • ASCII
        • CHAR
        • CONCAT
        • CONTAINS
        • ENDSWITH
        • FIND
        • ICONTAINS
        • IENDSWITH
        • ISTARTSWITH
        • LEFT
        • LEN
        • LOWER
        • LTRIM
        • REGEXP_EXTRACT
        • REGEXP_EXTRACT_ALL
        • REGEXP_EXTRACT_NTH
        • REGEXP_MATCH
        • REGEXP_REPLACE
        • REPLACE
        • RIGHT
        • RTRIM
        • SPACE
        • SPLIT
        • STARTSWITH
        • SUBSTR
        • TRIM
        • UPPER
        • UTF8
      • Function Availability
    • Parameters
  • DataLens Gallery
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. String functions
  4. ICONTAINS

ICONTAINS

Written by
Yandex Cloud
Improved by
amatol
Updated at December 19, 2025
View in Markdown

SyntaxSyntax

ICONTAINS( string, substring )

DescriptionDescription

Case-insensitive version of CONTAINS. Returns TRUE if string contains substring.

Argument types:

  • string — Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUID
  • substring — String

Return type: Boolean

ExamplesExamples

ICONTAINS("RU0891923", "ru") = TRUE
ICONTAINS("Lorem ipsum", "abc") = FALSE

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Trino, Yandex Documents, YDB.

Was the article helpful?

Previous
FIND
Next
IENDSWITH
© 2026 Direct Cursus Technology L.L.C.