Skip to content
v1.36.0
Install

STRCMP

STRCMP(string1, string2)

Section titled “STRCMP(string1, string2)”
  • string1: The first string to compare.
  • string2: The second string to compare.

Example

Section titled “Example”
SELECT STRCMP("Hello", "World");

Output

Section titled “Output”
-1

Explanation

Section titled “Explanation”

In this example, the STRCMP() function compares two strings “Hello” and “World”. The result is -1 because “Hello” is less than “World” based on the ASCII value.