Text comparisons are similar to numeric comparisons (see Numeric comparisons). For example, using the Employee table:
SELECT FirstName, LastName FROM Employee WHERE FirstName > "Jim";
The comparison is made alphabetically on the first letter, then the second letter and so on. The above would return "Julia" and "Phil" but not "Andreas", "Chris" or "Jim". Note that all text comparisons must appear between quotes.
See also: