Converts a number to a string.
length specifies the length of the resulting string. The length must be in the range 1 - 256.
decimals specifies the decimal position to round.
fillchar specifies the fill character to use to fill up to the length specified. Note: fillchar is optional.
This function returns a character string.
Calculated field example
If the Unit_price field contained the value 159.95, the following calculated field expression would return " 160": Str(Unit_price,6,0)
Note: If there is no fill character specified, the Str function pads the result with leading spaces to match the string length specified. You must ensure that a proper data length is selected for the calculated field.
If the Unit_price field contained the value 159.95, the following calculated field expression would return "***160": Str(Unit_price,6,0,"*")
Records with a Unit_price field value of 99.95 or 100.32 can be selected or found using the expression: Str(Unit_price,3,0)="100"