Hide numbers

[simoevry]

Hi

I want to hide numbers for example :

FROM TABLE CASES

COL1

00000000000012304 => 12304

0000000000000040012=> 40012

[Anonymous]

Looks like your COL1 field is in text format.

Try converting it to numeric format, maybe something like this :

     num(COL1)

[surendraj]

Try with

replace(trim(replace(COL1,'0',' ')),' ','0') as COL1

[simoevry]

Thanks for all