meta data for this page
  •  

F_2OF5CHECK

function from adhoc

Entrypoint twooffivecheck compatible with UTF-8

Inputs/Outputs

   Input	CSTRING(250) number to check as string

Output INTEGER checkdigit from input

F_2OF5

function from adhoc

Entrypoint twooffive compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as string
   Output     CSTRING(13)      complete 2 of 5 number include checkdigit

—

Syntax

   2 of 5 numbers.
   Variable length. Allowed characters are 0-9, all other characters will be taken away.
   Can be used for 2of5 industries and 2of5 interleaved.
   Test-SQL
   SELECT 5 AS ISCORRECT, F_2OF5CHECK('123456') FROM RDB$DATABASE;
   SELECT 5 AS ISCORRECT, F_2OF5CHECK('ABC123456XYZ') FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_2OF5CHECK('1234567') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_2OF5CHECK(NULL) FROM RDB$DATABASE;
   SELECT '1234565' AS ISCORRECT, F_2OF5('123456') FROM RDB$DATABASE;
   SELECT '12345670' AS ISCORRECT, F_2OF5('1234567') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_2OF5(NULL) FROM RDB$DATABASE;