Malcolm,

If your values will always be in that format and lenght, you can try something like this:

select Left(ltrim(rtrim(YourFieldNameHere)), 6) + ' - ' + SUBSTRING(ltrim(rtrim(YourFieldNameHere)), 8, len(YourFieldNameHere)-7) as YourNewValue

from Blah

Just replace "YourFieldNameHere" with your actual field/column name and see it that works for you.

Mark