Icon CurrToSQLStr Method

function CurrToSQLStr(Value: Currency; Scale: Integer=0): String

Call the CurrToSQLStr method to convert a Currency value to an SQL 2003 standard decimal constant string. All SQL and filter expressions in ElevateDB require standard decimal constants which use the period (.) as the decimal separator. Use the Scale parameter to specify the number of decimal places to use for the output string, or 0 to specify that the number of decimal places in the output string will depend upon the Currency value being converted.

Please see the Types topic for more information on the data types in ElevateDB and their literal representation.
Image