Quote:
	
	
		| 
					Originally Posted by iamskippy  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.