F_ORD

<< F_CHARACTER U_CHR | IBExpert UDF Functions | F_ROT13 >>

F_ORD

substitutable with ASCII_VAL

  • input/output-compatibility to rFunc (ORD)

U_ORD

  • function from adhoc
  • Compatible with UTF-8
  • Input VARCHAR(1) ASCII-Code-No.
  • Output SMALLINT Character of ASCII-Code-No.

Example 

 SELECT 65 AS ISCORRECT, F_ORD('A') FROM RDB$DATABASE;;

Expected results: 

    ISCORRECT        F_ORD
 ============ ============
           65           65

Example 

 SELECT NULL AS ISCORRECT, F_ORD(NULL) FROM RDB$DATABASE;

Expected results: 

 ISCORRECT        F_ORD
 ========= ============
 <null>          <null>

back to top of page
<< F_CHARACTER U_CHR | IBExpert UDF Functions | F_ROT13 >>