Re: case-insensitive sort

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sun, 12 Jan 2003 23:51:09 -0800
Message-ID: <3E226FED.434DE07B_at_exesolutions.com>


Andrey Voronov wrote:

> How I can implement case-insensitive sort without use function-based index?

SELECT ...
FROM ...
[Quoted] [Quoted] WHERE UPPER(field_name) = UPPER(some_value);

Daniel Morgan Received on Mon Jan 13 2003 - 08:51:09 CET

Original text of this message