>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?

I can think of a few possibilities:

1. Regionalization issue. In some areas of the world the value of 3000 is shown as 3,000.00. In others it's shown as 3.000,00. Windows regionalization may not be set as expected, or may not match SQL Server's settings.

2. If you're viewing the value with a textbox on a custom form, its display format is determined by properties such as .Format and .InputMask. If these are not blank, try setting them to blank to see if that makes a difference. Also if the textbox is a subclass you may have to play with the parent class properties.

3. Is the textbox simply too narrow to fully display the value?

4. Is there any intermediate processing of the values going on with, for example, the TRANSFORM() function?