MS Access StrComp() Function

Compare two strings:

SELECT StrComp("SQL Tutorial", "SQL Tutorial") AS CompString;

Definition and Usage

The StrComp() function compares two strings.

The result is returned as an integer based on the comparison:

StrComp( string1, string2, compare)

Parameter	Description
string1 and string2	Required. The two strings to compare
compare	Optional. The type of comparison to perform. Possible values: -1: Uses option compare 0: Binary comparison 1: Textual comparison 2: Comparison based on your database

Works in:	From Access 2000

Compare two strings:

SELECT StrComp("SQL Tutorial", "SQL") AS CompString;

Compare two strings:

SELECT StrComp("SQL", "SQL Tutorial") AS CompString;