你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

strcmp()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Compares two strings.

The function starts comparing the first character of each string. If they're equal to each other, it continues with the following pairs until the characters differ or until the end of shorter string is reached.

Syntax

strcmp(string1, string2)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
string1	string	✔️	The first input string for comparison.
string2	string	✔️	The second input string for comparison.

Returns

Returns an integer value indicating the relationship between the strings:

• <0 - the first character that doesn't match has a lower value in string1 than in string2
• 0 - the contents of both strings are equal
• >0 - the first character that doesn't match has a greater value in string1 than in string2

Example

Run the query

datatable(string1:string, string2:string) [
    "ABC","ABC",
    "abc","ABC",
    "ABC","abc",
    "abcde","abc"
]
| extend result = strcmp(string1,string2)

Output

string1	string2	result
ABC	ABC	0
abc	ABC	1
ABC	abc	-1
abcde	abc	1