Archives of the TeradataForum

Message Posted: Mon, 14 Jan 2013 @ 15:30:29 GMT

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

Since your column is character, you need to specify the range as quoted character strings:

     select case
              when col1 is between '0' and '100000'
              then col1
              else null
            end
     from tablename

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