concatenate two column.

[SWN]

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

[Dan Guzman]

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****@REMOVEy ahoo.dk> wrote in message
news:40******** *************@d read11.news.tel e.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

[SWN]

"Dan Guzman" <da*******@nosp am-earthlink.net> wrote in message
news:Xa******** **********@news read3.news.atl. earthlink.net.. .

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

Hi Dan.

I've just found the problem.
The db was portet from paradox to SQL Server.
I found that the all strings in the uname field ended with a square! ie. a
weird char.
I could not see it in the query analyzer. I saw by coincident in the open
table->return all rows
There must be a difference between those two??!!

That mean I will have to update all the fields with minus one character. ;o(

Thanks Svend