> 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]