Can yout try:

coalesce(substring(memofield from 1 for 1990), cast('' as varchar(1990))

On 12/6/06, Rick Roen <rick@...> wrote:
>
> Yes, It does extract from the BLOB with no problem (apparently). At
> least I get the text in the BLOB, but maybe something else as well?
>
> Rick
>
> >
> > I didn't know that SubString function could be used with blobs. I've
> only
> > ever used UDF functions to manioulate blob contents.
> > Alan
> >
>
>
>


[Non-text portions of this message have been removed]