Welcome to Sign in | Help

convert nvarchar to text

  •  10-24-2007, 11:46 AM

    convert nvarchar to text

    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? 

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems