Precision of fields in a view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there any way to control the precision of a field in an ADP view? My
SELECT statement is multiplying 2 fields to create a 3rd, and the number of
decimal places in the output field seems to be the maximum of the precisions
of the input fields.
 
Use the SQL Server CAST or CONVERT function to ensure that the output column
is of the appropriate data type.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Precision and Scale 1
Set Decimal Places 3
Number precision 3
Problems With Precision while Linking Tables 4
Access stripping decimal places in query 1
! Decimal Field Precision ! 2
Getting "Invalid precision for decimal data type" 1
Decimal, precision 6

Back
Top