SQL Functions

$CONVERT

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

See Also: CAST

Syntax

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

$CONVERT()

Required.

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.

top

Example

SELECT PRODUCTS.PRODUCT_NAME,

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

FROM PRODUCTS

top