Archives of the TeradataForum

Message Posted: Tue, 07 Apr 2009 @ 22:00:59 GMT

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

If you don't want to count Null values, you can either remove those null's by applying filter condition as

     Where L_name  is not null
     and f_name  is not null

     Else use Coalesce function.

     Coalesce(L_name,'unknown'),Coalesce(f_name,'unknown')

Regards,

Rakesh Saxena

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