Export SQL table into a fixed length format

I currently have data in my tables that are formatted like: County Office First Name Last Name 01 01 John Smith 99 01 Jane Cole I need to export it into a fixed length text file using SQL. Output should look like this: 0101JohnSmith 9901JaneCole Does anyone know how to do this?