<< 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 >>