In querying a table that has a column with datatype DECIMAL(22,7), it shows 0E-7 for 0 values in the result set.
SEL 0 (DECIMAL(22,7));
SEL 1 (DECIMAL(22,7));
Why is it doing that?
@EB180000, The data is displayed as it is returned from the database. If you enable the 1000's separator preference for the Result Set Viewer, it will format the result and display 0.0000000. We have are working on improvements in Studio and Studio Express in this area.