Subject | translate function |
---|---|
Author | danyschaer |
Post date | 2008-12-23T19:40:11Z |
Hi all,
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?.
Thank you.
Dany
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?.
Thank you.
Dany