STARTS_WITH

​

Syntax

​

Scalar

starts_with(value, search)

​

Arguments

​

Returns

• Type: BOOLEAN
• Possible values: TRUE or FALSE from a case-sensitive literal substring comparison.
• NULL behavior: Returns NULL if either argument is NULL.

​

Properties

​

Examples

​

Typical behavior

SELECT starts_with('abc', 'ab') AS found, starts_with('abc', '') AS empty_search;

​

Case-sensitive prefixes

SELECT starts_with('Order-42', 'Order') AS same_case, starts_with('Order-42', 'order') AS different_case;