Subject Re: [firebird-support] Re: 'like' with % at the begin finds nothing
Author Helen Borrie
At 09:46 PM 11/05/2006, you wrote:
>Thanks for the answer, but the suggestions to work around
>do not help me because
> o I have no influence on the db structure (it's not mine)
> o To pad the compare string at the end with blanks you need to
> to know the correct number of blanks at the end of the entry.
>The only workaround momentarily is to search for '%bcd%' and do
>some mor filtering on application level.

or use CONTAINING 'bcd'