<< F_CONVERTSYMBOLS U_CONVERTSYMBOL | IBExpert UDF Functions | F_STRIPSTRING F_BIGSTRIPSTRING U_STRIPSTRING >>

F_REVERSE

 
substitutable with REVERSE

• function from adhoc

 U_REVERSE

• function from adhoc
• Compatible with UTF-8
• Input VARCHAR(254) string to return backwards
• Output VARCHAR(254) string backwards

Upper-/lower-case stays as in the original string.

Example

 SELECT 'eman ruoY' AS ISCORRECT, F_REVERSE('Your name') FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_REVERSE                                                                                                                                               
 ========= ===============================================================================
 eman ruoY eman ruoY 

Example

 SELECT NULL AS ISCORRECT, F_REVERSE(NULL) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_REVERSE                                                                                                                                               
 ========= ===============================================================================
 <null>    <null> 

back to top of page
<< F_CONVERTSYMBOLS U_CONVERTSYMBOL | IBExpert UDF Functions | F_STRIPSTRING F_BIGSTRIPSTRING U_STRIPSTRING >>