Precision of fields in a view

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.
 
B

Baz

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
Problems With Precision while Linking Tables 4
Access stripping decimal places in query 1
Getting "Invalid precision for decimal data type" 1
! Decimal Field Precision ! 2
Linking different field types 2
dumb data type question 5

Top