Archives of the TeradataForum

Message Posted: Mon, 22 Oct 2001 @ 19:17:45 GMT

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

One possible answer is as follows. You can use a CAST function either inside the case statement on each clause (ex. CAST(nnnn as INTEGER) or you could wrap a CASE statement around the entire CASE statement ex.

CAST((CASE....WHEN....THEN....ELSE....) AS INTEGER)

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