Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to hide numbers for example :
FROM TABLE CASES
COL1
00000000000012304 => 12304
0000000000000040012=> 40012
Looks like your COL1 field is in text format.
Try converting it to numeric format, maybe something like this :
num(COL1)
Try with
replace(trim(replace(COL1,'0',' ')),' ','0') as COL1
Thanks for all