> > -----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');

Or use a case insensitive collation.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com