topic Re: Hide numbers in App Development

Hide numbers

simoevry — Wed, 15 Feb 2017 14:45:12 GMT

I want to hide numbers for example :

FROM TABLE CASES

COL1

00000000000012304 => 12304

0000000000000040012=> 40012

Anonymous — Wed, 15 Feb 2017 14:52:06 GMT

Looks like your COL1 field is in text format.

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

num(COL1)

surendraj — Wed, 15 Feb 2017 14:52:37 GMT

Try with

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

simoevry — Wed, 15 Feb 2017 17:00:34 GMT

Thanks for all