>> > 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');
>
> Or use a case insensitive collation.

Which one is case insensitive ??

Ivan