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