You need the SUBSTRING function:
SQL Server SUBSTRING() Function[
^] - if it's always just 10 chars, then it's trivial. If it's "up to the first space" then you need the CHARINDEX function as well:
SQL Server CHARINDEX() Function[
^]
In your case, You need to look more closely at your data - it's trimming to '-' so unless that exists in each row and in the right place you won't get what you want. Since your output seems longer that you are asking for, perhaps you need to review your inputs to decide what to do - we can't do that as we have no access to your data.
I would suggest creating TRIMTO user function and calling that instead of inlining the code though: it makes it a lot easier to read the rest of your query, and should be more efficient than repeatedly using CHARINDEX. Plus it's easier to debug and get right.