Hi Will,

> yeah you're right, it should have been:
>
> SELECT * FROM foo WHERE 'test@...' LIKE addr;
>
> which should, IMHO, work fine.

Did a quick test in the example database:

insert into country values ('test%', 'oink');
select * from country where 'testum' like country;

Output:

COUNTRY CURRENCY
=============== ==========

test% oink


This is Firebird 1.0 Windows Superserver. What server did you use?


Greetings,
Paul