Espera un momento, tienes razón; entre las funciones UDF que trae Firebird está
substr
Cita:
|
Empezado por archivo ib_udf.sql
/*****************************************
*
* s u b s t r
*
*****************************************
*
* Functional description:
* substr(s,m,n) returns the substring
* of s which starts at position m and
* ending at position n.
* Note: This function is NOT limited to
* receiving and returning only 80 characters,
* rather, it can use as long as 32767
* characters which is the limit on an
* INTERBASE character string.
* Change by Claudio Valderrama: when n>length(s),
* the result will be the original string instead
* of NULL as it was originally designed.
*
*****************************************/
|
Solamente tienes que ejecutar el script ib_udf.sql en FireBird para registrar la función y poder utilizarla
Saludos