startswith.md

description
This section contains reference documentation for the STARTSWITH function.

startswith

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