Page 1 of 1

How to check if a column is positive !!

Posted: Tue Jan 20, 2009 11:35 am
by its_me48
I have a column (Total_Amount; Decimal(38,2)) that I want to check in the transformer stage. I want to check if its positive number and put some logic... I know the logic but cannot figure out a way to check if the column is positive?

Any pointers please...

Thanks!!
-Sam

Posted: Tue Jan 20, 2009 11:39 am
by chulett
Generally, one would check if the value is greater than zero.

Posted: Tue Jan 20, 2009 11:51 am
by its_me48
Ahh.... how did I miss this one? Thanks chulett, this tip worked like a charm.
chulett wrote:Generally, one would check if the value is greater than zero. ...

Posted: Tue Jan 20, 2009 12:29 pm
by chulett
One of those days, I guess. :wink:

Please mark the post as Resolved using the button at the top of the screen !!