To remove last zeros in a particular column

[#1]

Hi Community,

How to  remove all the last zeros in a particular column like below.

Table:

Coulumn

50,

60,

400,

5050,

050,

Expected output is:

Column

5,

6,

4,

505,

05

Thank you

[robert_mika · Accepted solution]

=REPLACE(TRIM(replace(Column, '0', ' ')),' ',0)