Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JACKJPR

    SUBSTR & INSTR-Oracle

    Hi I am looking for the Oracle Function's like SUBSTR & INSTR in Informix.... Is there is any function in informix Like this.... Looking forward for your Helps... Thanks in advance for spending your valuable time Thanks Jack
  2. JACKJPR

    Decode in Group BY

    Here is the Sample Query SELECT replace(TABLE A.test_num,'^',' '), Decode(TABLE A.in_service,'Y','IN-SERVICE','N','NOT IN-SERVICE'), TABLE B.testtype, TABLE A.aim_count, count(TABLE A.test_id) FROM TABLE A, TABLE B, TABLE C, TABLE D WHERE ( TABLE A.test_type=TABLE...
  3. JACKJPR

    Decode in Group BY

    Hi I am new to INFORMIX....Not to Database..I am Working with Oracle for a long time. I am Using a decode statement & Count in my select...So i have to use a group by function in my SQL. If i use the Decode in my group by then i am getting an error "Syntax Error Has Occured-201" Any...

Part and Inventory Search

Back
Top