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

 

Related Topics Link IconRelated Topics