<div>
Can you recheck the Cleaned table?
</div>


<div>
try this query<br />
<br />
SELECT Cleaned.AddressCode, Cleaned.State<br />
FROM UMRM0112 Cogsdale<br />
INNER JOIN RP_CleanAddresses Cleaned ON Cogsdale.umAddressCode = Cleaned.AddressCode<br />
ORDER BY 2<br />
<br />
The nulls should show up at the bottom (or top)
</div>


try this query

SELECT Cleaned.AddressCode, Cleaned.State
FROM UMRM0112 Cogsdale
INNER JOIN RP_CleanAddresses Cleaned ON Cogsdale.umAddressCode = Cleaned.AddressCode
ORDER BY 2

The nulls should show up at the bottom (or top)

<div>
Argggg I do... WHERE State = NULL returned nothing?<br />
<br />
Can I replace the nulls with ' '?
</div>


Argggg I do... WHERE State = NULL returned nothing?

Can I replace the nulls with ' '?

<div>
Change the property of the data element STATE to allow nulls.
</div>


Change the property of the data element STATE to allow nulls.

<div>
<div class="content wysiwyg-content">
I'm trying to update a particular table with contents from another table but keep getting an error.<br />
<br />
UPDATE Cogsdale<br />
SET Cogsdale.ADDRESS1 = Cleaned.Address1, Cogsdale.ADDRESS2 = Cleaned.Address2,<br />
Cogsdale.umCityName = Cleaned.City, Cogsdale.State = Cleaned.State, Cogsdale.umZipCode = Cleaned.Zip<br />
FROM UMRM0112 Cogsdale INNER JOIN RP_CleanAddresses Cleaned<br />
ON Cogsdale.umAddressCode = Cleaned.AddressCode &nbsp;<br />
<br />
I get:<br />
Server: Msg 515, Level 16, State 2, Line 1<br />
Cannot insert the value NULL into column 'STATE', table 'test.dbo.UMRM0112'; column does not allow nulls. UPDATE fails.<br />
The statement has been terminated.<br />
<br />
I don't see any nulls in the State field... 
</div>
</div>


I'm trying to update a particular table with contents from another table but keep getting an error.

UPDATE Cogsdale
SET Cogsdale.ADDRESS1 = Cleaned.Address1, Cogsdale.ADDRESS2 = Cleaned.Address2,
Cogsdale.umCityName = Cleaned.City, Cogsdale.State = Cleaned.State, Cogsdale.umZipCode = Cleaned.Zip
FROM UMRM0112 Cogsdale INNER JOIN RP_CleanAddresses Cleaned
ON Cogsdale.umAddressCode = Cleaned.AddressCode  

I get:
Server: Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'STATE', table 'test.dbo.UMRM0112'; column does not allow nulls. UPDATE fails.
The statement has been terminated.

I don't see any nulls in the State field... 

Update Join Query Cannot insert Null

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.