> 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