Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=REPLACE(TRIM(replace(Column, '0', ' ')),' ',0)
=REPLACE(TRIM(replace(Column, '0', ' ')),' ',0)