Chapter 2: DataWindow Expression Functions

Asc

Converts the first character of a string to its ASCII integer value.

Asc ( string )

Argument	Description
string	The string for which you want the ASCII value of the first character

Integer. Returns the ASCII value of the first character in string.

Use Asc to test the case of a character or manipulate text and letters.

To find out the case of a character, you can check whether its ASCII value is within the appropriate range.

This expression for a computed field returns the string in code_id if the ASCII value of the first character in code_id is A (65):

If (Asc(code_id) = 65, code_id, "Not a valid code")

This expression for a computed field checks the case of the first character of lname and if it is lowercase, makes it uppercase:

IF (Asc(lname) > 64 AND Asc(lname) < 91, lname, WordCap(lname))