Hi

Anyone know of a function that would replace one charater with another
if the given char exists (in an update statement)

Basically I need to replace all spaces with ascii_char(xxx) for a
given column.

E.g. '8 100' should become '8♣100'

Thanks

Rod