HEIGHT

The HEIGHT function converts the string to a numeric value.

Output Type
numeric (feet and inches)
Fldargs
attrval
Number of standard roles
1
MinValue, MaxValue
36,90
  1. If conversion to a numeric value is not possible, then the attribute is treated as ANON.
  2. It is assumed that the input value is a three-digit integer, with the first digit being feet and the last two digits being inches (FII). This numeric value (which is in feet and inches) is converted to inches. For example 511 is equal to 5 feet, 11 inches and is ultimately converted to 71.
  3. This value is then checked to see if it falls between 36 and 90. If it does not fall within that range, the attribute is treated as ANON.
  4. The attribute is then converted back to a string format and added to the comparison string.

A height of 5'0 is converted to 60 inches.


Last updated: 27 Jun 2018