UPPER() is the only I know of that is built-in to both Interbase and
Firebird. Lower() seems to require UDF assistance.

-----Original Message-----
From: Nigel Weeks [mailto:nweeks@...]
Sent: Wednesday, February 09, 2005 4:03 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] convert field to lower/upper case in
where clause

> trouble is I'm not sure how to convert a field to lower case.
> to get the gist of what I am trying to acheive I have
> included the where
> clause below -- which does not work.
>
> select * from tblTest
> where LCASE(tblTest.first_name) = 'james'
>

You've almost got it!

select * from tblTest where lower(tblTest.first_name) = 'james';

Nige.

ps. I think the lower() and upper() are (still) UDF's, so remember to
declare the external functions if they don't work. I could be wrong on
this...!!!



[Non-text portions of this message have been removed]




Yahoo! Groups Links