willfordkc wrote:

> Is there a way to do a case insensitive select statement.
> Where
> Select * from table where name = 'john'
> would match 'john' 'John' 'JOHN' etc.

select * from table where UPPER(name) = 'JOHN';


Bye,

--
Milan Babuskov
http://fbexport.sourceforge.net