I wish to do an ODBC SQL query of an OE10 DB that was setup as case insensitive in a case sensitive fashion. Specificly, I would like to get a distinct list of the values in a field in a table showing all case versions of a given value like:
THE
The
the
...instead of just:
THE
Thanks.
THE
The
the
...instead of just:
THE
Thanks.