Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference NUMBERTOTEXT
Functions and Expressions Reference Guide
156
NUMBERTOTEXT
The NUMBERTOTEXT function converts a number to text that looks like the original
object.
Syntax
NUMBERTOTEXT (single-number-expression)
Meaning
NUMBERTOTEXT (number_to_convert)
Returns
This function returns a single-text-item.
Converts a character number to a text item. The resulting text looks like the
input argument. The result is truncated, if necessary.
Example
NUMBERTOTEXT (ROUND (1000 - 24.75, 3))
This example converts the result of the calculation (rounded to 3 decimal
places) to text, resulting in
975.250.
NUMBERTOTEXT (PurchaseNumber)
This example converts PurchaseNumber from a number to text.
Uses
Use
NUMBERTOTEXT when you need an object that is defined as a number
converted to an object defined as text. This is useful when you need to
concatenate text. The
FROMNUMBER function provides greater flexibility in
specifying the format of the resulting text item.
Related Functions
FROMNUMBER, TEXTTONUMBER, TODATETIME, TONUMBER