remove coma in select cause

[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

 

[nikhilparchure]

use the charindex function.
also in SQL Server there is replace() function , I doubtful about its presence in Sybase.