Replacing / with space

Hi,
I have a column with the following data.
A/B
X Y
Z
X/Y A/D
I want to replace the /with space so that I have the output-
A B
X Y
Z
X Y A D
Can I do that? Please let me know what SQL query will help.
Thanksreplace(column_name, '/', ' ')|||Or SHIFT-F1 will do the trick...|||Thanks a lot. Works.
Originally posted by joejcheng
replace(column_name, '/', ' ')|||No takers for your advice .. blindman

btw .. i tried shift + f1 .. but it didnt replace the / with ' ' ;)sql