Archives of the TeradataForum

Message Posted: Mon, 22 Oct 2001 @ 19:29:15 GMT


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

Subj:		Re: SQL question (see red line below)

From:		Geoffrey Rommel

In the following query, I want the result of the CASE which is put into "FLAG" to be an INTEGER field.

Why do you need to do this? All the results given in your THEN clauses are integers, so the end result of your CASE expression should be an integer.


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

Archives

2001 Indexes

Last Modified: 15 Jun 2023