Short of performing a binary comparison, is there a set or a hint that can
be applied to an MS SQL query that would allow it to temporarily ignore the
server case order? We're looking to perform a query that requires case
sensitivity but don't want to have to reconfigure the entire server.
I seem to vaugly recall a 'set nocase' option but can't recall exactly.