For somereason I found that Abs(T) returns 1 and TextToNum(T) returns 1 as well which is wrong. It should return empty.:??

But Abs(Any string except) or TextToNUm(Any string except)returns empty.

I think this is a FMP bug or do I miss any thing?

Thank you

This is expected behavior. See what happens with "Y" and "N". Now, if there are actual number in the field as well, e.g. T345, then the behavior will be different yet again.

Old Advance Man

Internally T = 1 = Y and F = 0 = N, so be aware when using these characters in boolean calculations.

P.S. by Boolean logic the above is totally correct.

Why they set internally T = 1 = Y and F = 0 = N? In what case do we need it? And is this FMP things only?Right?

Unless there is a good reason, otherwise I can use the If statement to set T = 1 = Y or F = 0 = N for my specific case?

Example:

If Left(Text, 1) = "T" do something, etc...... or

If Left(Text, 1) = 1 do something, etc...... or

Thanks

Use CASE statement rather than ensted IF's. It's easier to handle. The Y. N, T, F deals with boolean logic. And the rules vary, as I said, depending on whatelse is in the field.

Old Advance Man

Thank you for the information. But I wonder why

Abs(A) returns empty but

Abs(T) returns 1. It is NOT CONSISTANT? Because A and T both are characters.

Do you think? If they want to catch boolean, then they should have another built in function instead of Abs such as BL(T) will returns 1, etc....

Thank you

Y, T, F, and N are treated as boolean when they are used strictly by themselves in number fields. That's they way the program works. English version only. I believe the Spanish evrsion uses S and V instead of Y and T.

Old Advance Man