<< F_SQM | IBExpert UDF Functions | F_TAB >>

F_DSQM

• function from adhoc
• Compatible with UTF-8
• Input without
• Output VARCHAR(2) 2 single-quote-marks CHR(39)

Example

 SELECT 'ABC<2 single quote marks>123' AS ISCORRECT, 'ABC' || F_DSQM() || '123' FROM RDB$DATABASE;

Expected results:

 ISCORRECT                    CONCATENATION
 ============================ =============
 ABC<2 single quote marks>123 ABC''123

back to top of page
<< F_SQM | IBExpert UDF Functions | F_TAB >>