• Seems like a collation conflict. What happens if you specify the collation of the table variable?

    Ex:

    Declare @v_Temp_School Table (School Varchar (250) SQL_Latin1_General_CP1_CI_AS, Currency Varchar (20) SQL_Latin1_General_CP1_CI_AS)

    Insert Into @v_Temp_School (School )

    --insert into #Temp_MDL (school,currency)

    select ueb.evs_name from evs_unitExtensionbase ueb

    except

    select distinct school from #Temp_MDL --collate SQL_Latin1_General_CP1_CI_AS

    Select * From @v_Temp_School

    Insert Into #Temp_MDL ( School , Currency )

    Select School , '$' From @v_Temp_School

    Joie Andrew
    "Since 1982"