wackoj123 wrote:

>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?
>
>

I guess you should replace double quotes to single

Andrew