Conversion of nvarchar to Decimal

Epicor ERP 10
1

I am working in the BAQ editor program.

I am trying to add a calculated field to convert a nvarchar to decimal.

I am trying to convert an nvarchar of “1.8125” to a decimal and It always displays as 2.00.

I tried:
Convert(dec, UD100.Character01)
Round(Convert(dec,UD100.Character01))

but I can’t seem to get the full 1.8125 to show.

Any suggestions welcome.
DaveO 651-246-3281

2

You need to add in your precision:

convert(decimal (5,4), UD100.Character01)
3

Mr. Doug: Thank you - that is what i was missing.

Thank you so much.

DaveO