<< F_DQM | IBExpert UDF Functions | F_DSQM >>

F_SQM

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

Example

 SELECT 'ABC<Single quote mark>123' AS ISCORRECT, 'ABC' || F_SQM() || '123' FROM RDB$DATABASE;

Expected results:

 ISCORRECT                 CONCATENATION
 ========================= =============
 ABC<Single quote mark>123 ABC'123

back to top of page
<< F_DQM | IBExpert UDF Functions | F_DSQM >>