Hi everyone, after searching about on google, and the MySQL manual ... i can't seem to find an equivilent function in MySQL to Oracle's TRANSLATE() function... any ideas? if this is unclear, I can provide some more details. thanks in advance, Dylan