Null Field Displays Value

I have a table that has a number field that is nullable. There are 3 records in the field. The number field is null in every record. If I select all records from the table where the number field is NULL it returns 3 rows and displays the number field as null. If I select all of the fields from the table specifying each field name the number field is displayed with the letter n in it.

Select number_field from mytable where number_field is NULL;

This returns the null value

select abc, number_field, xyz from mytable;

This displays an 'n' in the number_field column.

Has anyone seen this before.

TIA Received on Wed Oct 30 2002 - 13:28:28 CST