要得到 00095001 - 00096000 这种格式的数据

qsh(起始号)到jsh（结束号）  要得到  00095001 - 00096000  这种格式的数据

SELECT LYR, LYSJ, PJCH, QSH || ' - ' || JZH QZH, FHSJ, FHR
  FROM SF_PJXX_T A, SF_PJXX_MX_T B
 WHERE 1 = 1
   AND A.BH = B.PJBH
/*  AND (LYR = ? OR ? IS NULL)
AND (LYSJ >= ? OR ? IS NULL)
AND (LYSJ <= ? OR ? IS NULL)
AND (PJCH LIKE ? OR ? IS NULL)
AND (FHR LIKE ? OR ? IS NULL)*/
 ORDER BY LYR