Variable with Concatenation in SQL

See more:

SQL

SQL-Server-2008R2

Dear All,

I declare three variable in below trigger, now i want to Concatenation with @AllVar.

When i do Concatenation got error Incorrect syntax near '+'. Why this?

create TRIGGER <TriggerName>
ON [dbo].<TableName>
FOR INSERT
AS
BEGIN
DECLARE @us_email varchar(500);
DECLARE @CallNo varchar(500);
DECLARE @AllVar varchar(500);
SET NOCOUNT ON;
IF EXISTS (SELECT * FROM inserted)
BEGIN
SELECT @us_email = EmailAddress
FROM inserted i,
Users u
SELECT @CallNo ='Notification :Call Number is :' + SPACE(1)+ CallNumber
FROM inserted
@AllVar='The Call Number is '+ @CallNo + ' and some Text'
END
END
GO

Thanks
Basit