Conversion Functions

The following functions can be used to convert data to different formats depending on your requirements.

Function

Usage

Description

DATESTR

Convert a date to a string

NUM

Convert a string to a number

SPECIALCHARS

Include non-printing characters in a text string

STR

Convert a number to a string

STRCONVERT

Convert a text string
STR2XMLDATA Return XML formatted string after conversion

STRTOLOWER

Convert text to lower case

STRTOUPPER

Convert text to upper case

TIMESTR

Convert a time to a string
XMLDATA2STR Return normal string after XML string conversion