good day!
how could i use the function translate to output the replacement of the
exact occurrence of the 2nd parameter?
for instance,
select translate('Juan dela Cruz C/O ABC Co.','C/O','c/o');
gives
translate
----------------------------
Juan dela cruz c/o ABc co.
i would like the output to be "Juan dela Cruz c/o ABC Co." instead of "Juan
dela cruz c/o ABc co." could i do this with the above function, or are
there any functions that could do this?
thank you very much!