Archives of the TeradataForum

Message Posted: Thu, 14 Nov 2002 @ 08:54:28 GMT

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

Reddy,

What tool are you using to issue the SELECT * ? And how does that tool display NULLs?

If you're using Queryman then it's default character for NULLs is '?'.

To verify that you've realy got NULLs loaded, try the following query (from any tool)

sel *
from xxx
where phoneno is null;

From what you've said you should get one row back.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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