CHR()

CHR() returns the UNICODE character corresponding to the decimal value that you specify. Used to reference any UNICODE character, especially those that cannot be entered directly from a keyboard or are unprintable. CHR() is the inverse of the ASCII() function.

Function Format

CHR(N)

CHR() returns the UNICODE character corresponding to the decimal value N. The value of N should be between 0 and 65535.

Note: The character of value zero is used as a string delimiter by Analyzer and produces unpredictable results if used.

Examples

You could use CHR() to add the UK pound symbol £ (UNICODE character 163) to values in a currency field for formatting purposes:

CHR(163)+"123.45"= "£123.45"

You could also use CHR() as part of a test to search fields or records for the existence of a specific non-printable character.