Text=Number returns correctly but LongText=number does not

Is there some underlying logic behind why LongText=Number returns incorrectly but Text=Number returns correctly? Yes I know I should compare the types to themselves but the auto generating always prefers longtext over text for me and sometimes I need to compare values that may contain either text/numbers to fields that only need to contain numbers.

0 2 212
2 REPLIES 2
Top Labels in this Space