Returns an integer value representing the Unicode character code (sometimes called the code point) for a character.

A Unicode character code is an integer from 0 to 65535.

This function returns 0 if Val is empty. If the current data value is NULL, Val is an empty string and 0 is returned.

How you specify a text string as an argument depends on whether you are using the function in an SQL query or in mrScriptBasic or mrScriptMetadata. In an SQL query, enclose text strings in single quotation marks (' '). In mrScriptBasic or mrScriptMetadata, enclose text strings in double quotation marks (" ").

This mrScriptBasic example uses the AscW function to return the character code for a single character:

The return value is 97.

The next example shows an SQL query that uses the AscW function to return the character code for the first character of the name variable (which stores the respondent's name).