1)To Use Replace

select replace(coName,'Char to Repalce','Char to Replace with')

2)Relace the leading zeros of text
SELECT REPLACE(LTRIM(REPLACE('094434580980','0',' ')),' ','0') FROM table1

3)Replace Trailing zeros of the text
SELECT REPLACE(RTRIM(REPLACE('094434580980','0',' ')),' ','0') FROM table1