SELECT FRM_UNIT_STD_HIS_ID,
       A.FRM_UNIT_STD_MGR_ID,
       KEY_CD1,
       KEY_CD2,
       KEY_CD3,
       KEY_CD4,
       KEY_CD5,
       CD1,
       CD2,
       CD3,
       CD4,
       CD5,
       ETC_CD1,
       ETC_CD2,
       ETC_CD3,
       ETC_CD4,
       ETC_CD5,
       STA_YMD,
       END_YMD,
       A.NOTE,
       CASE WHEN EDIT_FORMAT_K1 = '2' THEN ROW_NUMBER() OVER ( ORDER BY dbo.XF_TO_NUMBER(A.KEY_CD1)) 
	   ELSE ROW_NUMBER() OVER ( ORDER BY KEY_CD1) END AS ORDERING
  FROM FRM_UNIT_STD_HIS A,
       FRM_UNIT_STD_ETC B
 WHERE A.FRM_UNIT_STD_MGR_ID = 6502996
   AND A.FRM_UNIT_STD_MGR_ID = B.FRM_UNIT_STD_MGR_ID
   AND (( '2020-07-08 00:00:00.0' IS NULL) OR ( '2020-07-08 00:00:00.0'  BETWEEN STA_YMD AND END_YMD ))
   AND (NULL IS NULL OR KEY_CD1 LIKE NULL + '%')
   AND (NULL IS NULL OR KEY_CD2 LIKE NULL + '%')
   AND (NULL IS NULL OR KEY_CD3 LIKE NULL + '%')
   AND (NULL IS NULL OR KEY_CD4 LIKE NULL + '%')
   AND (NULL IS NULL OR KEY_CD5 LIKE NULL + '%')
 ORDER BY ORDERING