Firebird - Case Insensitive Queries

Firebird dose not support case insensitive queries.

Consider these options

One solution is to create a special field - "Some_Field_Upper" - and a trigger that automatically saves the upper case value. Then you just query the using the computed value.

This example is from Triggers in Firebird which provides a very good description of triggers.

Author: Robert Clemenzi -
URL: http:// / user / clemenzi / technical / Databases / Delphi / Firebird / Query_Case_Insensitive.html