PegoraroF10 <mar...@f10.com.br> writes: > I have to replace ; , " and ' chars in an string putting its correspondent > ascii value > I have a > Replace(Replace(Replace(Replace($$Text,with;On'It"$$,',','chr(59)'),';','chr(44)'),'"','chr(34)'),'''','chr(39)') > It works but I would like to call just one Replace.
Use translate(), perhaps? https://www.postgresql.org/docs/current/functions-string.html regards, tom lane
