meta data for this page
  •  

F_ISSN8CHECK

function from adhoc

Entrypoint issn8check compatible with UTF-8

Inputs/Outputs

   Input	CSTRING(250) number to check as string

Output INTEGER checkdigit from input

F_ISSN8

function from adhoc

Entrypoint issn8 compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as string
   Output     CSTRING(9)       complete, formatted ISSN-8 number include checkdigit

Syntax

   Fixed length of 8 characters (with hyphen 9). Allowed characters are 0-9, all other characters and all characters more than length 8 will be taken away.
   Test-SQL
   SELECT 9 AS ISCORRECT, F_ISSN8CHECK('0724-867') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ISSN8CHECK(NULL) FROM RDB$DATABASE;
   SELECT '0724-8679' AS ISCORRECT, F_ISSN8('0724-867') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ISSN8(NULL) FROM RDB$DATABASE;