Case Sensitive Search

Occasionally you may find it necessary to perform a case sensitive search in your data.  Using the COLLATE statement in the WHERE clause will allow you search for the exact case sensitive string you are looking for. Thanks to SQLMagRef139579