WITH t AS ( SELECT '가람한방병원[직원]' nm UNION ALL SELECT '가람한방병원[ABC]' UNION ALL SELECT '가람한방병원◆' UNION ALL SELECT '가은요양원' UNION ALL SELECT '건강나라요양병원[직원]' UNION ALL SELECT '건강나라요양병원[총무]' UNION ALL SELECT '건강나라요양병원◆' UNION ALL SELECT '공동체협동조합' UNION ALL SELECT '공동체협동조합[직원]' ) SELECT * FROM t ORDER BY REPLACE(nm, '◆', '[') ;