7.23 NUMSTR

Use the @NUMSTR function to convert a string (character) column or value into a number. Use @NUMSTR to do either of the following:

• Map a string (character) to a number.

• Use a string column that contains only numbers in an arithmetic expression.

Syntax

@NUMSTR (input)

input

Can be either of the following:

• The name of a character column.

• A literal string that is enclosed within single quote marks.

Example

PAGE_NUM = @NUMSTR (ALPHA_PAGE_NO)