Hi All

FireBird Quries are Case Sensitive?.

Just check out the following Query

SELECT * FROM EMPLOYEE WHERE LOCATION ='LONDON'

Returns 0 recods

While

SELECT * FROM EMPLOYEE WHERE LOCATION ='London'

works fine.

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

Dilish