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,',','');
UPDATE BEAN_ALL_NEW SET DEPTH_BN = REPLACE( REPLACE(DEPTH_BN,',',''),'"','');