XML Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

string

Converts a number or Boolean to a string.

Syntax

string ( value )

The following table describes the argument for this function:

Argument	Description
value	Numeric or Boolean value. Passes a number or Boolean value.

Return Value

String.

Returns an empty string if no value is passed. Returns NULL if a null value is passed.

The string function converts a number to a string as follows:

If the number is an integer, the function returns a string in decimal form with no decimal point and no leading zeros.

If the number is not an integer, the function returns a string including a decimal point with at least one digit before the decimal point, and at least one digit after the decimal point.

If the number is negative, the function returns a string that contains a minus sign (-).

The string function converts a Boolean to a string as follows:

If the Boolean is FALSE, the function returns the string “false.”

If the Boolean is TRUE, the function returns the string “true.”

Example

The following expression returns a string from the numeric argument speed:

string( SPEED )

The following table contains example arguments and return values:

SPEED	RETURN VALUE
10.99	‘10.99’
15.62567	‘15.62567’
0	‘0’
10	‘10’
50	‘50’
1.3	‘1.3’

The following expression returns a string from the Boolean argument STATUS:

string( STATUS )

The following table shows example arguments and return values:

STATUS	RETURN VALUE
TRUE	‘true’
FALSE	‘false’
NULL	NULL

Rename Saved Search

Table of Contents

XML Guide

XML Guide

string

string

Syntax

Return Value

Example