Archives of the TeradataForum

Message Posted: Thu, 29 Jan 2004 @ 09:47:41 GMT

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

Hi All,

I am having a table with a character field. The field has values like 'A' , 'E', 'P' , null and blank in it.

When I run a query to select rows where fieldval != 'P' , I get rows which have 'A' , 'E' and blank . Rows having null in the field are not returned. Is it the right behavior ??

Thanks and regards,

Rachana

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