number()

given a value, returns that value as a number syntax number(value) value the number , money , percent , enum , boolean , or string value to be converted by the function return type number docid\ uci5tctfvbhonej6zqijg sample usage number($100) returns 100 number(string(base)) returns the original value of base supported data types input type return type logic number docid\ uci5tctfvbhonej6zqijg number docid\ uci5tctfvbhonej6zqijg if a number value is passed, the same number value will be returned money docid ks5d2xbfor9d8wfrivny number docid\ uci5tctfvbhonej6zqijg if a money value is passed, the amount will be returned as a number percent docid\ fbn7bfahlfpv4f1c53dxa number docid\ uci5tctfvbhonej6zqijg if a percent value is passed, the amount will be returned as a number of subtype decimal where 50% is equivalent to 5 enum docid\ untq2eal5rmipnyczvfw1 number docid\ uci5tctfvbhonej6zqijg if a numeric scale enum value is passed, the numeric value is returned as a number boolean docid\ kdvwa4opcqwedhpycth4l number docid\ uci5tctfvbhonej6zqijg if a boolean value is passed, true will return the number value 1 , and false will return the number value 0 string docid\ ujw2aqaktel5uuklup73s number docid\ uci5tctfvbhonej6zqijg if a string value is passed, its constituent characters will be evaluated for compatibility with the number data type characters which are compatible will be returned as a number value if two or more sets of compatible characters are separated by non compatible characters (ex "121yes121" ), the compatible sets of characters will be returned as comma separated values (ex 121,121 ) unsupported data types null docid\ n9trvqonnbknql9drnbp6 unsupported data types return null