Remove characters from rightside
Ron KJan 9 2008 — edited Jan 10 2008In my query I select the following table
,pa_expenditure_items_all.ORIG_TRANSACTION_REFERENCE.
The output gives values like
12567245:2
12567244:2
12567247:3
9367349:2
9367349:4
I would like to remove the last two positions in this output.
However this proves to be, for me, more difficult then expected.
The total number of characters varies so i can't use SUBSTR with counting starting from the left side.
I tried REPLACE and TRIM but didn't get it right.
Hope someone can help my out on this.