IENDSWITH
Syntax
IENDSWITH( string, substring )
Description
Case-insensitive version of ENDSWITH. Returns TRUE if string ends in substring.
Argument types:
string—Boolean | Date | Datetime | Fractional number | Geopoint | Geopolygon | Integer | String | UUIDsubstring—String
Return type: Boolean
Examples
IENDSWITH("PETROV IVAN", "Ivan") = TRUE
IENDSWITH("Lorem ipsum", "SUM") = TRUE
IENDSWITH("Lorem ipsum", "abc") = FALSE
Data source support
ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.
Previous
Next