About a Select Query

Question

I want to get to know the SQL query to find names of a column (egCustomerName) whose names having (anyletter) ‘l’ as the third letter

Answer 1

Try this query

select * from tablename where CustomerName like '__I%'

Answer 2

You can get 3rd letter by using SUBSTRING.

Try something like this:

SELECT egCustomerName
FROM Table
WHERE SUBSTRING(egCustomerName, 3, 1) = 'l'

Answer 3

Can achieve this with both RIGHT and LEFT functions.

Query

select name from tblName
where right(left(name,3),1)='l';

Fiddle demo here

And can achieve this with SUBSTRING,LIKE,MID also.