how find character in string
R. RoyalMar 20 2006 — edited Mar 20 2006Hi,
I've table TAB_TEST:
ID............DESC_ID
1.............MY TABLE->YOUR TABLE
2.............DOG->X
6.............MY CATS->YOUR CATS
9.............WINDOWS->Y
7.............MY JOB->YOUR JOB
I'd like to write one query with DESC_ID after character "->"
In my case:
ID............DESC_ID
1.............YOUR TABLE
2.............X
6.............YOUR CATS
9.............Y
7.............YOUR JOB
How can I find the character "->" in DESC_ID and write from that character in then?
Thanks in advance!