Unable To Match Fields With Identical Contents

I am having trouble with a select statement where i try to use a variety of methods on two columns in different tables that, hypothetically, have exactly the same contents.

Below are the three Create Table statements, so you can see how everything is set up. The columns zone_monthly.specific and #temp_dec0607c.specifics come from almost the same original source, so I can't fathom how they could actually be different in their contents - I know some of the individual lines are the same.


Create Table category_specifics (ID integer, segment nvarchar(Max), specifics nvarchar(max))

BULK INSERT category_specifics

FROM 'c:USERSTEALDOCUMENTShonda_chartsmonthly_filescategory_list.txt'





Create Table zone_monthly (ID Integer, specific nvarchar(max), zone integer, dec06 money, dec07 money)

INSERT INTO zone_monthly (specific, zone)

SELECT specifics, '12' AS zone

From category_specifics




Create Table #temp_dec0607c (ID integer, specifics nvarchar(max), zone integer, dec07 money, dec06 money)

Bulk Insert #temp_dec0607c

FROM 'c:USERSTEALDOCUMENTShonda_chartsmonthly datazonedec0607.txt'


Now here is the SELECT statement that I am having trouble with - It returns no results, and, as I said before, I am rather certain it should return something. I have tried it with an inner join as well (code included), and again, no results.



SELECT #temp_dec0607c.zone, #temp_dec0607c.dec07, #temp_dec0607c.dec06

FROM #temp_dec0607c

WHERE

#temp_dec0607c.specifics=zone_monthly.specific


SELECT #temp_dec0607c.zone, #temp_dec0607c.dec07, #temp_dec0607c.dec06

FROM #temp_dec0607c

INNER JOIN zone_monthly ON

#temp_dec0607c.specifics=zone_monthly.specific

What on earth is going on?