SQL Object

NumberValue

Syntax

SQL.NumberValue(NumValue[, Decimals])

Description

Formats a numeric value in SQL text, including parameterizable decimals.

Parameter	Description
NumValue	A numeric or financial value.
Decimals	Optional. Determines the number of decimal places.

See Also

DateValue, TextValue

Example

Sub Main()
 
    MsgBox SQL.NumValue(123.45678, 3)    ' ROUND(123.45678,3)
    MsgBox SQL.NumValue(123.45678)      ' 123.45678
 
End Sub