Click here to Skip to main content
14,869,378 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
i need to find the nearest characters of barcode in an existing column using oracle query.

Example, i have a string of barcode = '1ABAFQW'.
I need to find the nearest last 3 digits 'FQW' , except '1ABA'.
How to find it.

What I have tried:

I tried to use REG_EXP function and also googled, but could not find any solution.
Can any one guide me for finding this solution.
Updated 26-Jan-21 23:29pm
OriginalGriff 27-Jan-21 4:33am
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with - so we have no idea how your barcode is stored, what you are searching for, what Regex you used, ... anything at all really!

Use the "Improve question" widget to edit your question and provide better information.

1 solution

Do you mean:
SELECT * FROM MyTable WHERE MyColumns LIKE '%' + 'FQW' + '%'

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900