STR ​
Converts numeric value to a character expression for creating long character strings or character comparisons.
Reporting Area(s) ​
General
Required Parameters ​
- Numeric expression to convert (i.e. fefee, pyamt, rgcrsefee, 15.75)
- Length of character string to return (i.e. 8)
Optional Parameters ​
- Number of decimals to return (i.e. 2)
Example(s) ​
STR(pyamt,8,2) returns payment amount as character expression with total length of 8 characters and 2 decimal points (i.e. 512.25)
STR(15.75,5,2) returns 15.75 as character expression
Notes ​
Standard FoxPro Function
This function allows you to combine number fields and character fields in one report expression (i.e. "wmtitle+' '+str(wmfeeamt,8,2)" converts fee amount to character then returns workshop title and fee amount).