|Subject||Re: [firebird-support] FireBird Case Sensitive Queries|
>> > as we are Converting our database from MSAccess & SQL ServerWhich one is case insensitive ??
>> > 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.