Subject Re: [ib-support] Re: where FIELD1 LIKE '%??? >
Author Helen Borrie
At 07:42 AM 13-12-02 +0000, you wrote:
>hi Daniel,
>Any update in this area?

For the LIKE predicate you have to have the '%' wildcard character in there
somewhere - before or after the search string, or both.
I didn't see the original posting but I wonder if you tried this:

select * from table1 where field1 like _UNICODE_FSS'%祧'

This won't be valid if field1 is not a unicode_fss column though.