update ships set name =
REPLACE(
    REPLACE(
        REPLACE(
            REPLACE(
                REPLACE(
                    REPLACE(
                        REPLACE(
                            REPLACE(
                                REPLACE(
                                    REPLACE(
                                        REPLACE(
                                            name,
                                            REPLICATE(' ', 12), ' '),
                                        REPLICATE(' ', 11), ' '),
                                    REPLICATE(' ', 10), ' '),
                                REPLICATE(' ', 9), ' '),
                            REPLICATE(' ', 8), ' '),
                        REPLICATE(' ', 7), ' '),
                    REPLICATE(' ', 6), ' '),
                REPLICATE(' ', 5), ' '),
            REPLICATE(' ', 4), ' '),
        REPLICATE(' ', 3), ' '),
    REPLICATE(' ', 2), ' '
)