Yandex DataLens

Getting started
Use cases
Step-by-step instructions
Concepts
- Service overview
- Connection
- Data types
- Datasets
- Charts
- Dashboards
- Using Markdown in DataLens
- DataLens Public
- Calculated fields
  - Overview
  - Formula syntax
- Marketplace
- Backups
- Quotas and limits
Access management
- Managing access to DataLens
- Managing access at the data row level
Pricing policy
- Current pricing policy
- Archive
  - Rules before March 1, 2021
Function reference
- All Functions
- Aggregate functions
- Date/Time functions
- Geographical functions
- Logical functions
  - Overview
  - CASE
  - IF
  - IFNULL
  - ISNULL
  - ZN
- Mathematical functions
  - Overview
  - ABS
  - ACOS
  - ASIN
  - ATAN
  - ATAN2
  - CEILING
  - COS
  - COT
  - DEGREES
  - DIV
  - EXP
  - FLOOR
  - GREATEST
  - LEAST
  - LN
  - LOG
  - LOG10
  - PI
  - POWER
  - RADIANS
  - ROUND
  - SIGN
  - SIN
  - SQRT
  - SQUARE
  - TAN
- Operators
- String functions
- Text markup functions
- Time series functions
- Type conversion functions
- Window functions
  - Overview
  - AVG
  - AVG_IF
  - COUNT
  - COUNT_IF
  - FIRST
  - LAG
  - LAST
  - MAVG
  - MAX
  - MCOUNT
  - MIN
  - MMAX
  - MMIN
  - MSUM
  - RANK
  - RANK_DENSE
  - RANK_PERCENTILE
  - RANK_UNIQUE
  - RAVG
  - RCOUNT
  - RMAX
  - RMIN
  - RSUM
  - SUM
  - SUM_IF
- Function Availability
Questions and answers

ISTARTSWITH

Written by

Syntax

ISTARTSWITH( string, substring )

Description

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

Examples

ISTARTSWITH("petrov ivan", "Petrov") = TRUE

ISTARTSWITH("Lorem ipsum", "LORE") = TRUE

ISTARTSWITH("Lorem ipsum", "abc") = FALSE

Data source support

Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, Oracle Database 12c (12.1), PostgreSQL 9.3.