STRCMP (Lakehouse v2)

Compares two strings lexicographically. Returns 0 if equal, -1 if str1 < str2, 1 if str1 > str2.

Analyze Syntax

func.strcmp(<str1>, <str2>)

Analyze Examples

func.strcmp('abc', 'abd')

┌────┐
│ -1  │
└────┘

SQL Syntax

STRCMP(<str1>, <str2>)

SQL Examples

SELECT STRCMP('abc', 'abd');

┌────┐
│ -1  │
└────┘