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.










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

> > I have a blob field, this field is always lines of text. Each

line

> > has a CR character in the end.
> >
> > I need to build a view to show the first 3 lines in 3 different
> > fields.
> > I do not want to create a new UDF function, just to use SP

language

> > or to use the standard UDF libraries. Is it possible?
> >
> > Please, any help well be welcome.
> >
>
> there is a standard UDF which returns a substr of a blob
> Alan