How do I display the name of employee whose name contains a as fourth letter

Question

1.00/5 (2 votes)

See more:

I am in 10th class and this can come in my boards, please help me, I wanna know that if I have to use 3 underscores in front of A?? And can I just use 4 underscores if in the question the A is in 5th place?

What I have tried:

Nothing as I don't have a PC or a Laptop

Posted 9-Mar-23 18:04pm

Otaku Prikshit

Updated 9-Mar-23 22:26pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2023-03-09T19:20:00

Solution 2

'_' is SQL for "match any single character", and "%" is SQL for "Match any number of characters" So for A as fourth letter:

SQL

SELECT * FROM Employees WHERE EmpName LIKE '___A%'

And for A in the fifth letter:

SQL

SELECT * FROM Employees WHERE EmpName LIKE '____A%'

Posted 9-Mar-23 19:20pm

OriginalGriff

Member 15627495 · Answer 2 · 2023-03-09T19:15:00

Solution 1

as the underscore is '1' characters, the '%' is any length pattern.

where name like '___a%' // [ 4 '_' ]

"yes If 5 _ are needed, you can use them.

Posted 9-Mar-23 19:15pm

Member 15627495

Updated 9-Mar-23 19:53pm

CHill60 · Answer 3 · 2023-03-09T22:26:00

Solution 3

Just for completeness and to offer an alternative, depending on platform and version of SQL you are using, you could also use

SQL

where substring(name, 4,1) = 'A';

This would be my preference as it is immediately apparent which character I am querying

Posted 9-Mar-23 22:26pm

CHill60