SUBSTR
Syntax
SUBSTR( string, from_index [ , length ] )
Description
Returns the substring string starting from the index from_index.
If an additional argument length is specified, a substring of the specified length is returned.
Argument types:
string—Stringfrom_index—Integerlength—Integer
Return type: String
Example
SUBSTR("Computer", 3) = "mputer"
Data source support
ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.
Previous
Next