Hello all,
I am trying to include the substring in my select statement and something is not right, can anyone help.
I need to get 2 different words "Campus" and "DL" from the string.
They do not have specific lenth so I tried following
select
(substr('string1', Instr('string','Campus',1,1)) from table
select
(substr('string1', Instr('string1','DL',1,1)) from table
but it is not working. and is there a wayto concatinate 2 substr statements?
Really appreciate any help. TIA
IP Logged
