Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
  • Blog
  • Pricing
  • Documentation
Yandex project
© 2025 Yandex.Cloud LLC
Yandex DataLens
    • Overview
    • Formula syntax
      • 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
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. String functions
  4. ISTARTSWITH

ISTARTSWITH

Written by
Yandex Cloud
Improved by
amatol
Updated at November 6, 2024

SyntaxSyntax

ISTARTSWITH( string, substring )

DescriptionDescription

Case-insensitive version of STARTSWITH. Returns TRUE if string starts with substring.

Argument types:

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

Return type: Boolean

ExamplesExamples

ISTARTSWITH("petrov ivan", "Petrov") = TRUE
ISTARTSWITH("Lorem ipsum", "LORE") = TRUE
ISTARTSWITH("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, Yandex Documents, YDB.

Was the article helpful?

Previous
IENDSWITH
Next
LEFT
Yandex project
© 2025 Yandex.Cloud LLC