Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 10:23:35 GMT

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

Hi,

You can use between operator for this

     case when columnname between 'a' and 'z'
          then 0 else cast(columnname as decimal(10,4)) end

Regards

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