--- In firebird-support@yahoogroups.com, "tdtappe" <tappe@t...> wrote:

> Does it make sense that I get a result if I say
>
> WHERE Column LIKE '%'
>
> but I do not get a result if I say
>
> WHERE Column LIKE '~%'
>
> although there a records in the table with values in Column like
> "~one" or "~two".
>
> The same problem arises with "#" instead of "~".
>
> Could it be some character set problem?
>
> I use FB 1.5.2
>
> --Heiko

Hello Heiko

I do not have this problem with 1.5.2

select *
from employee
where FirstName like '~%'

returns 1 record after the appropriate manipulations to the data. My
table does not use a character set (at least there is none defined by
me), so I can't rule that out.

But make sure the transaction that sets the column name to start with
the ~ is committed.

Adam