Archives of the TeradataForum

Message Posted: Fri, 13 Sep 2002 @ 20:18:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This select will do the job. Just substitute your column for "somenumber".

Select cast((somenumber(format'9999')) as char(4))

Tony

	<Prev	Next>		<<First	<Prev	Next>	Last>>