f$SQLNumValue
f$SQLNumValue
Add a value to an SQL WHERE clause as a number. This function can also be applied as desired to convert a number into a string.
Syntax: | Z1 = f$SQLNumValue( Param ) | ||
| Argument | Type | Meaning |
| Param | -any- | Value to be added |
Result: | String |
| |
Example: | Length = 1200 SQL = 'select * from Table where Length > ' SQL = SQL + f$SQLNumValue( Length ) Result on the SQL parameter: select * from Table where Length > 1200.000000 | ||