Archives of the TeradataForum
Message Posted: Thu, 29 Jan 2004 @ 09:47:41 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|