> Is there in Firebird a function for doing character replacements like
> this:
>
> select * from tbl where translate(col, 'áéíóú', 'aeiou') like '%martin%'
>
> ... so it will return rows where col has "martín" or "martin".
>
> Is it an internal function or other way for doing that?.

This sort of things is usually done by using case-insensitive/accent-insensitive
collation, e.g. as part of table definition:

CREATE TABLE TBL (
COL VARCHAR(20) CHARACTER SET ISO8859_1 COLLATE FR_FR_CI_AI );

...
select * from tbl where col like '%martin%';

or

select * from tbl where col containing 'martin';

Ivan
http://www.volny.cz/iprenosil/interbase/