Convert Character to Number
Posted: Tue Nov 04, 2014 7:23 pm
Hi, in table Stock, the field Stock_in is defined as Char.
In a report I want a rule that says
stock->stock_in > 0 - that's zero, not O.
but the rule is throwing up an error because I am comparing a Char to a Number.
How do I correctly compare the two?
Thanks
In a report I want a rule that says
stock->stock_in > 0 - that's zero, not O.
but the rule is throwing up an error because I am comparing a Char to a Number.
How do I correctly compare the two?
Thanks