Archives of the TeradataForum

Message Posted: Fri, 16 Apr 2004 @ 13:19:43 GMT

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

The CASE statement is going to be executed where you write it.

If you put it in the SELECT, it will test the data after it gets past the WHERE clause. Therefore, it is using SPOOL just the same as any other function.

If you write it in the WHERE clause, it tests the data along with the WHERE clause.

I hope this helps clear up some of your confusion.

Michael Larkins
Certified Teradata Master

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