Functions

$CONVERT

The $CONVERT function converts a scalar_expression from one data type to another of length n. This function may also be used for formatting data.

See Also: CAST

Syntax

$CONVERT(scalar_expression, datatype, n [,options])

scalar_expression
Required. The original data that is to be converted.

datatype
Required. A valid Omnidex datatype.

n
Required. The length of the newly converted data.

options
Optional. Valid options.

Example

SELECT PRODUCTS.PRODUCT_NAME,
$CONVERT(PRODUCTS.COST,'C STRING',32,'PICTURE"$^^^,^^^,^^^.^^"')
FROM PRODUCTS

Top