Skip to content
Advertisement

Query to get all those names of employees,who have ‘A’ as their middle character in their name

E.g:- BRAKE,CRANE etc.

In my employees table , I have ENAME,ENO,JOB,SALARY.

Here, I want to extract out those enames that have an ‘A’ as the center character in their name.

If length of ename is odd,then center one, so i need to detect odd and even position in ename.

So, I tried this, but stuck up ,so can i expect a help from here?

Advertisement

Answer

This works for odd length strings, which I think is what you wanted. Next time please don’t use caps like that. It took me 5 minutes just to read your post.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement