Converting numbers to alphanumeric strings using a Built-In function

Date: Archived
Product/Release: LANSA - All Platforms
Abstract: Sometimes negative numbers do not convert successfully to alphanumeric strings. There is a Builtin function available that will solve this.
Submitted By: LANSA Technical Support

The SUBSTRING command can be used to convert numbers to alphanumeric strings. If the numeric value is negative, however, problems may be encountered. The minus sign (-) will not be converted by the SUBSTRING command.

There is a builtin function available in LANSA that solves this problem. The function, called NUMERIC_STRING, ensures that the minus sign is also used in the conversion.

Here is an example :