f$SQLChrValue
f$SQLChrValue
Add a value to an SQL WHERE Clause as a string, i.e. mask with the character " ’ ".
Syntax: | Z1 = f$SQLChrValue( Param ) | ||
| Argument | Type | Meaning |
| Param | -any- | Value to be added |
Result: | String |
| |
Example: | SQL = 'select * from T_Anschrift where Preferredname like ' SQL = SQL + f$SQLChrValue( 'ABB%' )x Result on the SQL parameter: select * from T_Anschrift where Preferredname like 'ABB%' | ||