Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Unanswered: convert text field type to string

    Hello!

    I want to extract some part of text field and convert into string...

    I use a querry like these

    select SUBSTRING (text_field1 FROM 3 FOR 2) from table1 where ...

    can i use o querry like this...select (CAST text_filed as varchar(8))..or something like that?...i'm beginner with informix....

    Thank you!
    Last edited by xamukoru; 06-05-06 at 05:47.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please test running SELECT text_field1[ 2,3] from table1 where...

    Gustavo.

Posting Permissions

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