Remove the Middle Name letter from firstName Column in SQL : <p>I have a column with FirstName = JOYCE A 
I want to remove the "A" i.e, middle name &amp; write the SQL command for it 
Result should be <code>FirstName = JOYCE</code></p>

<p>Please help.</p>
