select top 10 * from TB_COMPANY_EXH where 1=1 and isnull(del,'') <> 'Y' and isnull(del,'') <> 'Y' and syear = '2024' and ( state = 'Y' or state = 'Y1' ) and (left(upper( replace(replace(replace(replace(replace(replace(replace(replace(replace(company_name_kor,'(한)',''),'(유)',''),'(주)',''),'(사)',''),'유한회사',''),'주식회사',''),'사단법인',''),'㈜',''),' ','') ),1) like '[%u3148-%uCC27]' or left(upper(company_name_eng),1) like '[%u3148-%uCC27]') ORDER BY case when company_name_kor like '' then 2 else 1 end, replace(replace(replace(company_name_kor,'(사)',''),'(재)',''),'(주)','') asc K-PRINT 2025