Hi all,

I have a query:

SELECT * FROM MY_TABLE
WHERE (Code LIKE "__AB")

to get all codes that end in ..AB, but not in ..AAB. This works
perfectly in Interbase 6.5 but returns an empty dataset when using
Firebird (1.0.2.908 Win32).

Is this a known issue? Does Firebird not support LIKE query where a _
indicates one character? (I noticed that "%AB" does work, but that's
not what I need :-))

Any suggestions?

Jack