A script-enabled browser is required for this page to function properly.

Comparing Strings in a WHERE Clause

Character strings in a WHERE clause are compared using the characters’ binary values: a character is 'greater than' another if it has a higher binary value in the database character set. Because the sequence of characters based on their binary values may not match the alphabetic sequence for a language, the comparisons often do not follow alphabetic conventions. Use the NLSSORT function to perform a linguistic sort instead of a binary sort.