Got a view that gets data from SQL server.
In view have a numeric field n(14,2). In sql the value is 3000 but in the view it is 3,000 ( with comma) If you select the field it changes to 3 . it seems the comma cannot be interpruted in the numeric field and thus truncates ie val(3,000) = 3 and not 3000.
Any ideas how to correct this?
Tks