remove coma in select clause

[pavikavi]

hi

Is it possible to remove coma from the select clause in a procedure

For example lets say i Select a, b, c from table1, table2...etc where value of a is "Proctoer, Gamble"
I need to remove the coma and replace it with space
is it possible in a procedure , is there any built in fucntion i can use

Please help me out

Thanks
pavithra