Skip to content

STR

Converts numeric value to a character expression for creating long character strings or character comparisons.

Reporting Area(s)

General

Required Parameters

  1. Numeric expression to convert (i.e. fefee, pyamt, rgcrsefee, 15.75)
  2. Length of character string to return (i.e. 8)

Optional Parameters

  1. 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).

SUBSTR
TRANSFORM
VAL