How to check if a column is positive !!

its_me48 · Post by **its_me48** » Tue Jan 20, 2009 11:35 am

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

chulett · Post by **chulett** » Tue Jan 20, 2009 11:39 am

Generally, one would check if the value is greater than zero.

its_me48 · Post by **its_me48** » Tue Jan 20, 2009 11:51 am

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. ...

chulett · Post by **chulett** » Tue Jan 20, 2009 12:29 pm

One of those days, I guess.

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