Skip to Content
0
Former Member
Aug 04, 2015 at 06:59 AM

How to remove comma from integer or decimal or any datatype columns of a table

2932 Views

Hello

I want to remove comma from a decimal column filed of HANA ,as when i am trying to use those data fields in some reporting tool , the charts are not getting represented correctly.

For example a field with data like 1,000.00 i want them to be presented as 1000 .

I have tried the following query but it seems, it doesn't affect the table field though it executed correctly.

UPDATE BEAN_ALL_NEW SET DEPTH_BN = REPLACE(DEPTH_BN,',','');

and

UPDATE BEAN_ALL_NEW SET DEPTH_BN = REPLACE( REPLACE(DEPTH_BN,',',''),'"','');

Regards

Debasis Nayak