This content has been marked as final. Show 4 replies
select * from tbl_example where surname like 'ABC_____%' or surname like 'ABC_____%';
_ = Provide 4 underscores for 4 characters and 5 for 5 characters.
Better way use regexp_like where you can use [:digit:] for the digits and more.....
Thanq Guys and I got the answer for this we need to use the Escape Sequences like the Keyword "ESCAPE"..
SELECT * FROM TABLE_NAME WHERE COLUMN_NAME LIKE 'ABC____%' ESCAPE '%'..
This will help...
I got the Answer my last Post is the Answer..