CAPITAL Office Business Software

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

Fixed - I found the asVar function. thx

Also to compare variables of different types, use the type conversion functions. Common ones include:

Val(Char) --> Numeric
Str(Numeric) --> Char