Hello.

I'v one table called big_strings:

create table big_string
(
field_example text
)

I'm trying do the SQL:

select substr(field_example,1,3) from big_string;

But I got error: "Blobs are not allowed in this expression"

Well, the same happen with like.

There are some way to select part one string in text field in a sql expression ?

Hi,

Do like this:

select field_example[1,3] from big_string;

Hope it helps... If it doesn´t work try to look at:

IBM Informix Dynamic Server v10 Information Center

Bye,