SELECT DISTINCT CONCAT(TMC.EBU_COUNTRY_CODE,
  (CASE WHEN LEN(TMC.LOCATION_TABLE_NR) = 1 THEN CONCAT('0',TMC.LOCATION_TABLE_NR)
        WHEN LEN(TMC.LOCATION_TABLE_NR) = 2 THEN CONCAT('',TMC.LOCATION_TABLE_NR)
        ELSE NULL END),
  (CASE WHEN TMC.TMC_PATH_DIRECTION = '+' THEN 'P'
        WHEN TMC.TMC_PATH_DIRECTION = 'P' THEN 'P'
        WHEN TMC.TMC_PATH_DIRECTION = '-' THEN 'N'
        WHEN TMC.TMC_PATH_DIRECTION = 'N' THEN 'N' ELSE NULL END),
  (CASE WHEN LEN(TMC.LOCATION_CODE) = 2 THEN CONCAT('000',TMC.LOCATION_CODE)
        WHEN LEN(TMC.LOCATION_CODE) = 3 THEN CONCAT('00',TMC.LOCATION_CODE)
        WHEN LEN(TMC.LOCATION_CODE) = 4 THEN CONCAT('0',TMC.LOCATION_CODE)
        WHEN LEN(TMC.LOCATION_CODE) = 5 THEN CONCAT('',TMC.LOCATION_CODE)
        ELSE NULL END)) TMC,
  TMC.ROAD_DIRECTION
FROM RDF_LINK_TMC TMC
ORDER BY 1;