meta data for this page
  •  

F_ISBN10CHECK

function from adhoc

Entrypoint isbn10check compatible with UTF-8

Inputs/Outputs

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

F_ISBN10

function from adhoc

Entrypoint isbn10 compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as string
   Output     CSTRING(13)      complete, formatted ISBN-10 number include checkdigit

Syntax

   Fixed length of 10 characters (with hyphens 13). Allowed characters are 0-9, all other characters and all characters more than length 8 will be taken away.
   Test-SQL
   SELECT 3 AS ISCORRECT, F_ISBN10CHECK('3-88229-192') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ISBN10CHECK(NULL) FROM RDB$DATABASE;
   SELECT '3-88229-192-3' AS ISCORRECT, F_ISBN10('3-88229-192') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ISBN10(NULL) FROM RDB$DATABASE;