ZEROES in Decimal data

[durgaps]

Hi,

I have a decimal column of format Length=16 and Scale=6 coming from a text file. There is a check in the Transformer stage in the derivation tab as "If Trim(In_Col) = 0 Then Space(17) else Trim(In_Col)". But the check for ZEROES is not happening, but when i changed the check to "If Trim(In_Col) = '0000000000.000000' " then the check for ZEROES is happening. But i need to check for a generic value for ZEROES i.e. the check has to be for '0'. Is there any way I can achieve it?

Thanks,

[ray.wurlod]

The zeroes are displayed by View Data so that you can verify that precision and scale are being handled properly. You can do regular comparisons (such as InLink.MyColumn = 0.0) to test for zero. You ought not to need the Trim() functions at all.

[kumar_s]

Is it you are converting the decimal to varchar, else space and trim wont help you.