vreau sa convertesc un nvarchar in tex
select +i.text+' ,'+i.tel+' ,'+convert(nvarchar(11),i.data_anunt,104)
from tbldiverse i
where data_anunt+28>=getdate() order by i.text,i.tel,i.data_anunt
i.text e de tip text
i.tel e nvarchar
am incercat select i.text+', '+ convert(text,i.tel) da nu merge
Msg 402, Level 16, State 1, Line 1
The data types text and varchar are incompatible in the add operator.
cum concatenez un text cu un nvarchar sau varchar?