<< F_RC | IBExpert UDF Functions | F_STRCMP U_STRCMP >>

F_EQUALSTRING

• compatibility to FreeUDFLib AvERP, GrUDF
• input/output-compatibility to rFunc (CEQUAL)
• Compatible with UTF-8
• Input VARCHAR(8190) String 1, VARCHAR(8190) String 2
• Output INTEGER 1 = is equal, 0 = is not equal

Example

 SELECT 1 AS ISCORRECT, F_EQUALSTRING('John like to drive fast', 'John like to drive fast') FROM RDB$DATABASE;

Expected results:

    ISCORRECT F_EQUALSTRING
 ============ =============
            1             1

Example

 SELECT 0 AS ISCORRECT, F_EQUALSTRING('Jane like to drive fast', 'John like to drive fast') FROM RDB$DATABASE;

Expected results:

    ISCORRECT F_EQUALSTRING
 ============ =============
            0             0

Example

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

Expected results:

 ISCORRECT F_EQUALSTRING
 ========= =============
 <null>           <null>                

back to top of page
<< F_RC | IBExpert UDF Functions | F_STRCMP U_STRCMP >>