si usas firebird, con UDFs
Hola
si usas firebird (y supongo que interbase tambien) puedes compilar la UDF
substr
* 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 255 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.
y con esta podrias hacerlo dentro de una consulta sql
Saludos
Pablo
|