meta data for this page
  •  

F_CROSSSUM

function from adhoc

Entrypoint crosssum compatible with UTF-8

Inputs/Outputs

   Input      INTEGER     natural number
   Output     INTEGER     cross sum from input

Syntax

   The cross sum is the addition of the digits of a number.
   i.e. 12345: 5+4+3+2+1 = 15
   Test-SQL
   SELECT 15 AS ISCORRECT, F_CROSSSUM(12345) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_CROSSSUM(NULL) FROM RDB$DATABASE;