I want to hide numbers for example :
FROM TABLE CASES
00000000000012304 => 12304
Looks like your COL1 field is in text format.
Try converting it to numeric format, maybe something like this :
replace(trim(replace(COL1,'0',' ')),' ','0') as COL1
Thanks for all
Retrieving data ...