ORDER 순서 숫자 -> 한글 -> 영문 순서를 숫자 -> 영문 -> 한글

SELECT Co
FROM (
    SELECT '가나상사' AS Co
    UNION ALL
    SELECT '(주) 가나상사'
    UNION ALL
    SELECT '가다상사'
    UNION ALL
    SELECT 'OK유통'
    UNION ALL
    SELECT '역삼유통'
    UNION ALL
    SELECT '123마트'
    ) x
ORDER BY LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(Co,'사단법인',''),'주식회사',''),'(주)','')))

SELECT Co
FROM (
    SELECT '가나상사' AS Co
    UNION ALL
    SELECT '(주) 가나상사'
    UNION ALL
    SELECT '가다상사'
    UNION ALL
    SELECT 'OK유통'
    UNION ALL
    SELECT '역삼유통'
    UNION ALL
    SELECT '123마트'
    ) x
ORDER BY UNICODE(LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(Co,'사단법인',''),'주식회사',''),'(주)',''))))