OOTP Developments Forums - View Single Post - How do I get rid of Null character (Catobase)?

SandMan · 07-02-2005, 12:11 AM

The easiest way is to open the table in MSACCESS. Create a query that gets all the records with a NULL in the manager field or nickname field. Change the query to an update query and update the fields that contain a null but should be blank to IS NOT NULL. You cannot change it to spaces, it will rewrite as a null but you can change it to the IS NOT NULL value, which will load spaces into the field.

07-02-2005, 12:11 AM	#3
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	The easiest way is to open the table in MSACCESS. Create a query that gets all the records with a NULL in the manager field or nickname field. Change the query to an update query and update the fields that contain a null but should be blank to IS NOT NULL. You cannot change it to spaces, it will rewrite as a null but you can change it to the IS NOT NULL value, which will load spaces into the field.