Deleting a % character in a cell. 1

[damipera]

Hi guys, can you please point me to the right direction? I have a table that's something like this:

id  mydescription  col1   col2   col3...
1    description1  12%     23%     34%
2    description2  45%     56%     67%
3    description3  78%     89%     90%
.
.
.

How can I write a SQL that would delete the percent(%) symbol starting from column1 to column3... something like this:

id  mydescription  col1   col2   col3...
1    description1  12     23     34
2    description2  45     56     67
3    description3  78     89     90
.
.
.

Thanks for any info.

 

[imex]

Hi,

Try something like this:

update MyTable
set col1 = replace(col1, '%', ''),
    col2 = replace(col2, '%', ''),
    col3 = replace(col3, '%', '')

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos[/url]

 

[damipera]

Hi Imex, thank you very much. It did the trick! Have a nice day.