Chr Function

Description

Returns the character value of a number.

Syntax

Chr(number)

Arguments

number can be a constant, a numeric field, an expression that results in a number, or a function that returns a number. For predictable results, the number should be in the range 0-255 (the extent of the character set).

Return value

This function returns a string.

Calculated field example

If the Amount field contained the values 876.00 and ¥1022 (indicating an amount in Japanese yen), the following calculated field expression would return the string Dollars or Yen: If(Left(Amount,1)=Chr(165), "Yen","Dollars")

The first part of this expression - If(Left(Amount,1)=Chr(165) - determines whether the Yen symbol (character code 165) appears at the beginning of the Amount field. If it does, the first value "Yen" is returned, otherwise the second value "Dollars" is returned.

Filter/Find example

Records with an Amount field value beginning with the yen symbol (¥) can be selected or found using the expression: Left(Amount,1)=Chr(165)