Total mental block here as not needed to do this for a while, whats the command to replace text in a variable on the way out (ie the equivalent of a javascript VAR.replace() type command)

Ie

Select Name.replace('Chip', 'Cunt') from Users

Its NOT that, just hopefully that should make sense as to what im trying to do!