 |
 |
Archives of the TeradataForum
Message Posted: Fri, 19 Oct 2001 @ 14:52:38 GMT
| Subj: | | Re: Case statements |
| |
| From: | | Geoffrey Rommel |
| | We regularly use CASE statements in our code as they are excellent in that only one pass of a table is required to satisfy a
query. | |
This is a small point, but everyone should be aware that these are CASE expressions, not statements. 'x' is an expression; 'y = x +
5' is a statement. Similarly, SELECT is a statement; CASE ... END is an expression within the statement.
I mention this because V2R4.1 will have a CASE statement (only within stored procedures, I think), so it may become important to keep
this distinction in mind.
--wgr
| |
