Fixed length zero padded number format?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 17 Mar 2003 18:50:17 GMT
Message-ID: <JNoda.10899$UE.5971796@twister.socal.rr.com>

Is there a format model that will give a fixed length zero padded number for both positive and negative values?

It's the way Oracle handles signs that causes the problems. For positive values it puts in a space where I want a zero (or the digit from the number). Currently I have to use 2 different format models and a case statement. For example ...

TO_CHAR(NUM_COLUMN,
  CASE WHEN NUM_COLUMN < 0
    THEN 'S00'
    ELSE 'FM000'
  END) Thanks,
Richard Kuhler Received on Mon Mar 17 2003 - 12:50:17 CST