On Fri, 24 May 2002 11:08:34 -0600
"Russell Black" <russell.black@iarchives.com> wrote:
> The EJB container does it for me, and it wants to do a
> SELECT * FROM t1 WHERE f1 = 'whatever';
> Instead of
> SELECT * FROM t1 WHERE lower( f1 ) = 'whatever';
You could have it run the SELECT on a view, where the relevant
column is defined using lower() on the appropriate column
of the real table.
Cheers,
Neil
--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC