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