Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: Substr in Text Field.

    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 ?

  2. #2
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    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,
    LS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •