select lastnames, length(lastnames)  as len
from pat
where len>4

I know that that the where statement need to be change.

Carlos

<<
select lastnames, length(lastnames)  as len
from pat
where len>4
>>

You have to repeat the expression at the where clause
select lastnames, length(lastnames)  as len
from pat
where length(lastnames)>4

Eduardo