Archives of the TeradataForum

Message Posted: Sun, 23 Apr 2006 @ 18:48:04 GMT

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

Thanks Dieter,

Now I Came to know from users that they can also denote NULL as 'E' (Empty). In plain english my requirements are

If Name = 'A' and (Value IS NOT NULL OR VALUE <> 'E' ) Then VALUE else get the value of the name 'B'. Basically I need to select name value pairs for each member in a web based application.

Thanks,

Naveen.

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