Get the last name of all the customers whose the last name is made up of 4 letters. how can I do it?

Answer 1

SELECT LAST NAME FROM TABLE WHERE LENGHT(LAST NAME) =4

Answer 2

you can also use like operator with 4 underscore.
select last_name from employees where last_name like '____';

Answer 3

use % after like condition

Answer 4

length option worked. 4 underscore with Like option didn't work.
thanks folks!

Answer 5

Roasekamal in which database you tried that? It works in oracle as tested myself.