F_

F_STRRM U_STRRM

function from adhoc
Compatible with UTF-8
Input VARCHAR(8190) where a character string had to be removed, INTEGER String Place in the string, which is to be removed
Output VARCHAR(8190) string with the removed string

counting starts with 0

Example

 SELECT 'his is just a Test' AS ISCORRECT, F_STRRM('This is just a Test', 0) FROM RDB$DATABASE;

Expected results:

 ================== ==================================================
 his is just a Test his is just a Test

Example

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

Expected results:

 ========= ===========================================================
 <null>    <null>

Follow IBExpertise on:

edit SideBar