<< F_PRED U_PRED | IBExpert UDF Functions | F_LOWER F_ANSILOWERCASE U_LOWER >>

F_SUCC

• function from adhoc

U_SUCC

• function from adhoc
• Input VARCHAR(1) Character, INTEGER Amount of characters behind the character in ASCII-Table
• Output VARCHAR(1) n-successor of character from parameter 1

If parameter 2 is equal to 512 (or multiple of 512) the return is the same as the input.

Both functions ignore UTF8 chars

Example

 SELECT 'a' AS ISCORRECT, F_SUCC('b', -1) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_SUCC
 ========= ======
 a         a

Example

 SELECT 'c' AS ISCORRECT, F_SUCC('b', 1) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_SUCC
 ========= ======
 c         c

Example

 SELECT 'b' AS ISCORRECT, F_SUCC('b', 512) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_SUCC
 ========= ======
 b         b

Example

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

Expected results:

 ISCORRECT F_SUCC
 ========= ======
 <null>    <null>                  

back to top of page
<< F_PRED U_PRED | IBExpert UDF Functions | F_LOWER F_ANSILOWERCASE U_LOWER >>