2. PHPRunner General questions
  3. [SOLVED] MS SQL money field displays two extra zeros in field
This topic is locked
[SOLVED]

MS SQL money field displays two extra zeros in field

 		11/4/2021 1:48:51 PM
PHPRunner General questions
J
 jwehner author

I have a MS SQL field that is showing up with extra zero's. I see no way of removing these. When I save the edit page it errors out even though it's a valid value in the database. It's adding these zero's somehow.

Any ideas?

Screen shot of issue:

img alt

Thanks!
J
 		jwehner author 11/4/2021

Of course I find the issue after I post. This is the soultion I came up with but there may be a better way.

On the SQL query I change the field to this:

CAST(OrigBalanceAmount AS DECIMAL(18,2)) as OrigBalanceAmount,