Hi Dilish,

> -----Original Message-----
> as we are Converting our database from MSAccess & SQL Server
> how does it possible to query the same without any case
> sensitive issues.

You could use something like:

SELECT * FROM EMPLOYEE WHERE UPPER(LOCATION) = UPPER('LONDON');

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage