I have a table with the following:
select * from test;

PREFIX PREFIX_ID
--------------- ------
07769 1
07770 2
07771 3
0776 4
077 5

I now want to select the prefix_id with the correct prefix,
e.g.
select prefix_id where substr(prefix,?) like '077696666444'
I think I will need a substr here, but how do I manage the length of the prefix column etc.
Can anyone help? Thanks.