simplifying a LEFT / REPLACE query
===

I have a query that is in dire need of being simplified. Here is part of the query:

    SELECT
        LEFT(MLIS.REQUESTOR_FIRST_NAME, CharIndex( ' ', MLIS.REQUESTOR_FIRST_NAME + ' ' ) - 1)
        
        , CharIndex( ' ', LEFT(MLIS.REQUESTOR_FIRST_NAME, CharIndex( ' ', MLIS.REQUESTOR_FIRST_NAME + ' ' ) - 1) + ' ' ) - 1)
        
        +REPLICATE(' ',25),25)+
        LEFT(' '+REPLICATE(' ',20),20)+
        LEFT(
        
        LEFT(
        
        LEFT(MLIS.REQUESTOR_LAST_NAME, CharIndex( ',', MLIS.REQUESTOR_LAST_NAME + ',' ) - 1)
        
        , CharIndex( ',', LEFT(MLIS.REQUESTOR_LAST_NAME, CharIndex( ',', MLIS.REQUESTOR_LAST_NAME + ',' ) - 1) + ',' ) - 1)


the reason I am doing the `replicates` is because i am building a fixed length string. each column needs to be a fixed length.

in addition to the above query, for every occurrence of `MLIS.REQUESTOR_FIRST_NAME` and `MLIS.REQUESTOR_LAST_NAME` i need to do:

    REPLACE(REPLACE(MLIS.REQUESTOR_FIRST_NAME,', MD',''),',MD','')

and

    REPLACE(REPLACE(MLIS.REQUESTOR_LAST_NAME,', MD',''),',MD','')

How do I include these `REPLACES` in the query and simplify the entire thing?

thanks so much for your guidance and kind help.