Please see my other Database Development articles.
Performing case-sensitive String Comparison
While using other string functions or operators may be used to compare strings, the most effective method remains the system function binary_checksum.
Here’s an example of how it may be used.