hi guys,

Actually, i solved my problem by changig the query to this one :

SELECT DISTINCT Cast(Cast(tablre1.Col1 as nVarchar(2))+Cast(tabble1.col2 as nVarchar(3))) as nvarchar(5)) , Cast(Cast(tablre2.Col1 as nVarchar(2))+Cast(tabble2.col2 as nVarchar(3))) as nvarchar(5))

FROM...

The query on witch i'm struggling is the following :

SELECT DISTINCT Cast(Cast(Col1 as nVarchar(2))+Cast(col2 as nVarchar(3))) as nvarchar(5)) as invalidValue

FROM Table1

WHERE Cast(Cast(Col1 as nVarchar(2))+Cast(col2 as nVarchar(3))) as nvarchar(5))

NOT...

Jeff Moden (5/4/2009)

How serendipitous... I've recently made that same discovery with doing things...