I get the expected results with the script below. Does this work for you?
If not, please post a complete script that illustrates the problem.
CREATE TABLE tblUser
(
uname nvarchar(100) NOT NULL,
uaddress nvarchar(50) NOT NULL
)
INSERT INTO tblUser VALUES('John', 'abc')
INSERT INTO tblUser VALUES('Mary', 'def')
SELECT
uname + ' ' + uaddress AS NameAdr
FROM tblUser
--
Hope this helps.
Dan Guzman
SQL Server MVP
"SWN" <sv****@REMOVEyahoo.dk> wrote in message
news:40*********************@dread11.news.tele.dk. ..
hi.
Trying to concatenate two columns:
select uname+' '+uaddress as NameAdr from tblUser
I only get the first field, name!!??
The datatype is both nvarchar. 100 and 50 chars long.
If I run this query:
select uname, uaddress from tblUser
theres no problem.
Any suggestions?
Thanks
SWN