DSXchange

Hi All,

I need to some help with decimal value comparsion.
Iam having source field col1 as datatype Decimal(38,10)

Requirement value
If col1=0.5Then 5
Else 0

Input Value : 0000000000000000000000000000.5000000000

please advice me how to compare decimal value with 0.5.

Thanks,
chandra

Your input value, is that what View Data shows? And what happened when you tried to compare those values?

These are two representations of the same value. They will compare equal.

Exactly... hence my second question.