meta data for this page
  •  

F_GTIN8CHECK

function from adhoc

Entrypoint gtin8check compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as string
   Output     INTEGER          checkdigit from input

Syntax

   Calculating the checkdigit of a GTIN number. Spaces, hyphens and digits more than max. length are ignored.
   Test-SQL
   SELECT 0 AS ISCORRECT, F_GTIN8CHECK('1234567') FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_GTIN8CHECK('1-2a3b4c5d6e7fxx999') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_GTIN8CHECK(NULL) FROM RDB$DATABASE;
   SELECT 2 AS ISCORRECT, F_UPC12CHECK('12345678901') FROM RDB$DATABASE;
   SELECT 7 AS ISCORRECT, F_GTIN13CHECK('762220000460') FROM RDB$DATABASE;
   SELECT 8 AS ISCORRECT, F_GTIN14CHECK('0123456789012') FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_NVE18CHECK('01234567890123456') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_GTIN8CHECK(NULL') FROM RDB$DATABASE;