This content has been marked as final. Show 3 replies
How to write SQL query to select the name whose 4th character is _
You can use a LIKE expression if you escape the underscore for the 4th character
See Aman's answer in this recent thread.
select * from emp where job like '___/_%' escape '/';
Re: Bit Confusion
Using LIKE or SUBSTR won't allow any index on that column to be used.