List the employees whose last names begin with an "L"
<p>In SQL Server Management Studio</p>

<p>List the employees whose last names begin with an "L". Both first name and last name appear in the same column called employeename and the last name is the second word.</p>

<p>This is what I came up with but only works for first name since is the first word:</p>

<pre><code>SELECT employeename
FROM employee_T 
WHERE employeename LIKE 'L%' 
</code></pre>

<p>So what can I add to make it work?</p>