View Single Post
Old 08-17-2012, 11:48 AM   #7
striperman36
Old Guy
iTrader: (0)
 
striperman36's Avatar
 
Join Date: Oct 2004
Location: Mansfield, MA
Posts: 8,760
Quote:
Originally Posted by iamskippy View Post
I have the conversions with no problem but will this do the same as a if,then statement as the column produces 7 different 2 digit numbers.
Posted from my iPhone/Mobile device
every value will be converted yes,

to_char(x,'99')

its how the variables are processed regardless of the variable value as long as it doe not exceed two characters.
striperman36 is offline   Reply With Quote