Can anyone let me know how I can achieve this
I have a column Bus_name varchar(55) in which some names have commas in them , they need to be removed while doing a select on the column
Kegs Bar and grill,inc
Shapiro company inc
Lincoln Abraham inc
Kegs Bar and grill inc
Appreciate your help
You have not explained with other columns. Let me assume that you can try thus: select oreplace (col1,',','')||oreplace (col2,',','')||oreplace (col3,',','') from table1.
For space use ||' '|| say like select oreplace (col1,',','')||' '||.....
If you want to append with text then select 'collect stats on '
I am having
select cola , col b, orreplace(bus_name, ',' ,' ') col c,
It is throwing error
A column or character expression size is larger than max size