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)