Hello,
Could you please give me advice on this problem. My task was to add new column SUM which will count values in two columns and in this column are decimal values with a dot, but I want decimal values with a comma, how can I change it? This is my query:
“SELECT :QUANTITY + :QTY_WAIV_DEV_REJ
FROM INVENTORY_VALUE_PART_LEVEL_EXT”
I tried this command:
“SELECT REPLACE(TO_CHAR(:QUANTITY, '99999999.9'), '.', ',') +
REPLACE(TO_CHAR(:QTY_WAIV_DEV_REJ, '999999999'), '.', ',')
FROM INVENTORY_VALUE_PART_LEVEL_EXT “
in SQL works, but in IFS it didnt retrieves any data.
