how to convert numeric to nvarchar in sql command

Asked 2011-12-07T06:45:15.113

I need to convert a numeric value to nvarchar in sql command.

Can anyone please help me.

sql sql-server-2005

Edit Report

2 Answers

select convert(nvarchar(255), 4343)

Should do the trick.

answered 2011-12-07T06:50:00.057

declare @MyNumber int
set @MyNumber = 123
select 'My number is ' + CAST(@MyNumber as nvarchar(20))

answered 2011-12-07T06:49:08.680