selecting a text in a column

This indicates some of your rows do not have a '[' present in them.

Try this:

SELECT CASE WHEN CHARINDEX('[',body) > 0 THEN LEFT(body,CHARINDEX('[',body)-1) ELSE body END 
  FROM emailBodyFile