How do people work around this at present? I absolutely *must* have case-insensitive indexed searches in my application.
I store my critical string fields twice, in two separate columns, one column has the user-desired case, and the other column has the same data in all upper case.
Then, when I want to search without considering case, I take my search terms, convert them to all upper case, and search against the upper-case column. thanks, bryan
