All Forums Tools
15 Mar 2006

I have value like "89237498 876345876 737 U " in attribute named NUMBER......... it is a concatenation of '89237498 876345876' ; '737' and 'U' .Now from Number i have fetch '89237498 876345876' into FNUM, '737' to SNUM and 'U' into TNUM atrributesIam using the following query for thisselectSUBSTR('89237498 876345876 737 U ',1,index('89237498 876345876 737 U ',' ')-1)This is fetching my first output as i wish........... But iam not able to fetch SNUM and TNUM Its is similar to INSTR in oracleINSTR('NUMBER',1,1) but this fun contains number of appearences. Can u help the same with Index.

You must sign in to leave a comment.