Comparing decimal value

moulipx · Post by **moulipx** » Sun Apr 28, 2013 7:54 am

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

chulett · Post by **chulett** » Sun Apr 28, 2013 8:10 am

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

ray.wurlod · Post by **ray.wurlod** » Sun Apr 28, 2013 2:21 pm

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

chulett · Post by **chulett** » Mon Apr 29, 2013 7:29 am

Exactly... hence my second question.