meta data for this page
  •  

F_SUCC

function from adhoc

Entrypoint successor not compatible with UTF-8 - use U_SUCC

U_SUCC

function from adhoc

Entrypoint u_successor compatible with UTF-8

Inputs/Outputs

   Input     CSTRING(1)      Character
             INTEGER	       Amount of characters behind the character in ASCII-Table
   Output    CSTRING(1)      n-successor of character from parameter 1

Syntax

   Is parameter 2 equal to 512 (or multiple of 512) the return is the same as the input.
   Test SQL
   SELECT 'a' AS ISCORRECT, F_SUCC('b', -1) FROM RDB$DATABASE;
   SELECT 'c' AS ISCORRECT, F_SUCC('b', 1) FROM RDB$DATABASE;
   SELECT 'b' AS ISCORRECT, F_SUCC('b', 512) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_SUCC(NULL, NULL) FROM RDB$DATABASE;
   SELECT '¤' AS ISCORRECT, U_SUCC('£', 1) FROM RDB$DATABASE;
   SELECT '×' AS ISCORRECT, U_SUCC('Ö', 1) FROM RDB$DATABASE;
   SELECT 'Γ' AS ISCORRECT, U_SUCC('Ώ', 4) FROM RDB$DATABASE;
   SELECT 'ぎ' AS ISCORRECT, U_SUCC('え', 6) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, U_SUCC(NULL, NULL) FROM RDB$DATABASE;