meta data for this page
  •  

F_UPSTNCHECK

function from adhoc

Entrypoint upstncheck compatible with UTF-8

Inputs/Outputs

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

F_UPSTN

function from adhoc

Entrypoint upstn compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as string
   Output     CSTRING(18)      complete, formated UPS tracking number include checkdigit

Syntax

   UPS Tracking-Nummer.
   Fixed length of 18 characters. Allowed characters are 0-9 and A-Z, all other characters and all characters more than length 18 will be taken away.
   Test-SQL
   SELECT 6 AS ISCORRECT, F_UPSTNCHECK('1Z 591580 68 5558773') FROM RDB$DATABASE;
   SELECT 6 AS ISCORRECT, F_UPSTNCHECK('591580685558773') FROM RDB$DATABASE;
   SELECT 6 AS ISCORRECT, F_UPSTNCHECK('59158068555877311111111') FROM RDB$DATABASE;
   SELECT 3 AS ISCORRECT, F_UPSTNCHECK('1Z 0F6915 68 2239322') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_UPSTNCHECK(NULL) FROM RDB$DATABASE;
   SELECT '1Z 591580 68 55587736' AS ISCORRECT, F_UPSTN('1Z 591580 68 5558773') FROM RDB$DATABASE
   SELECT '1Z 0F6915 68 22393223' AS ISCORRECT, F_UPSTN('1Z 0F6915 68 22393223') FROM RDB$DATABASE
   SELECT NULL AS ISCORRECT, F_UPSTN(NULL) FROM RDB$DATABASE;