Thank you, the problem is that I cannot use UDF functions if they are
not in the standard UDF libraries (IB_UDF and FBUDF).
I have seen that F_BLOBMID belongs to the EX_FUNCS library, not
included in the standard Firebird release, so I cannot use it for
several reasons.

I am looking for an alternative, without to install new libraries.

Thanks again for your time.






--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > I think that you mean "substr" funcions, but it is not work for my
> > question.
> >
> > substr(s,m,n) returns the substring if you knows the start and

end

> > point, but the problem is that in a text, the line lengths are not
> > constant. I need a function to find the CR character.
> >
> >
>
> No - it's reference is
> F_BLOBMID
> It takes a blob, start and length as argumetns and returns a string

of max

> length 1024
> Alan