Omnidex SQL Function: $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

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

Required. The original data that is to be converted.

Required. A valid Omnidex datatype.

Required. The length of the newly converted data.

Optional. Valid options.

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