STARTSWITH

​

Syntax

​

Scalar

startswith(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 startswith('abc', 'ab') AS found, startswith('abc', '') AS empty_search;

​

Case-sensitive prefixes

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