Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    8

    Unanswered: how to chage this informix sql to oracle sql?

    hi,

    anyone know how to chage this informix sql to oracle sql?

    select cust_name[1,40] from customer;

    the original cust_name is char(60), i just want its first 40 character. how to do that?

    thanks for ur help!


    best regards,
    jason

  2. #2
    Join Date
    Jun 2004
    Posts
    2
    Quote Originally Posted by jasontck
    hi,

    anyone know how to chage this informix sql to oracle sql?

    select cust_name[1,40] from customer;

    the original cust_name is char(60), i just want its first 40 character. how to do that?

    thanks for ur help!


    best regards,
    jason
    Please use Function Substr(str,begin,length)
    select Substr(cust_name,1,40) as cust_name
    from customer;

    best regards,
    Demerzel

Posting Permissions

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