Help Center/ Data Warehouse Service/ SQL Syntax Reference (9.1.0.x)/ Functions and Operators/ String Processing Functions and Operators/ Comparing Strings
Updated on 2026-05-29 GMT+08:00
View PDF

Comparing Strings

STRCMP(text, text)

Description: Compares two strings. If all strings are the same, 0 is returned. If the first string is less than the second string according to the current classification order, -1 is returned. Otherwise, 1 is returned. If the parameter contains NULL, NULL will be returned.

Return type: text

Example:

1
2
3
4
5
 
SELECT STRCMP('AA', 'AA'), STRCMP('AA', 'AB'), STRCMP('AA', 'A');
STRCMP  |  STRCMP  |  STRCMP
------------------------------
    0   |    -1    |     1
(1 row)

Parent Topic: String Processing Functions and Operators