meta data for this page
  •  

F_CODE39CHECK

function from adhoc

Entrypoint code39check compatible with UTF-8

Inputs/Outputs

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

F_CODE39

function from adhoc

Entrypoint code39 compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as a string
   Output     CSTRING(13)      complete code 39 number include checkdigit

Syntax

   Code-39 (3 of 9) number.
   Variable length. Allowed characters are 0-9, A-Z and $ % + - . / and space, all other characters will be taken away.
   Test-SQL
   SELECT 'K' AS ISCORRECT, F_CODE39CHECK('AB-123') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_CODE39CHECK(NULL) FROM RDB$DATABASE;
   SELECT 'AB-123K' AS ISCORRECT, F_CODE39('AB-123') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_CODE39(NULL) FROM RDB$DATABASE;