Loading lesson path
Concept visual
Start at both ends
StrComp("SQL Tutorial", "SQL Tutorial") AS CompString;The StrComp() function compares two strings. The result is returned as an integer based on the comparison:
Formula
If string1 = string2, this function returns 0
If string1 < string2, this function returns - 1
If string1 > string2, this function returns 1
If string1 or string2 is null, this function returns nullstring1, string2, compare )
Required. The two strings to compare compare Optional. The type of comparison to perform.
-1: Uses option compare 0: Binary comparison 1: Textual comparison 2: Comparison based on your database
SELECT StrComp("SQL Tutorial", "SQL") AS CompString;SELECT StrComp("SQL", "SQL Tutorial") AS CompString;❮ MS Access Functions