startswith

This section contains reference documentation for the STARTSWITH function.

returns true if columns starts with prefix string.

Signature

STARTSWITH(col, prefix)

Usage Examples

SELECT STARTSWITH('Apache Pinot', 'Apache') AS value
FROM ignoreMe
value

true

SELECT STARTSWITH('Apache Pinot', 'Pinot') AS value
FROM ignoreMe
value

false

PrevioussqrtNextST_AsBinary

Was this helpful?