-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|