select substring(blob_column from 1 for 100) from table

Regards,

Fabiano.

On 11/16/06, L <lfeliz@...> wrote:
>
> Hello.
>
> Is it possible to extract the first 100 characters or something like
> the MidStr(src,strart,length) function to extract n chars from a text
> blob? I have a situation I am looking to not have to write
> procedural code to do this and it would be nice to do this via SQL.
> Goal is to also be able to update a text field in the record with the
> first n charcters contained in the text blob as well as possibly
> select the first n characters from a Blob.
>
> Any help or hints would be greatly appreciated.
>
> - Lou
>
>
>


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