Remove space from field

[ynnepztem]

I have a stored procedure that concatenates two fields into one. The problem is that it puts a space between the two values. I need to know how to either take the space out or how to concatenate them without the space going there in the first place.

My stored procedure is as follows:

ALTER proc SetID
as
update ss4input
set id = datereceived + ein

The datereceived field is just an eight digit date like 10/21/02
The ein field is a nine digit field like 123456789

My result is 10/21/02 123456789 and it should be
10/21/02123456789
Any help is appreciated.

I am using SQL Server 2000 and Windows NT 4.0

 

[miq]

hi,

try this. it should work




ALTER proc SetID
as
update ss4input
set id = RTrim(datereceived) + LTrim(ein)


bye
miq

 

[ynnepztem]

Works perfect, thank you very much.