I am trying to concat a string within RAISERROR()
Something like this:

RAISERROR('Error' + CAST(@@ERROR AS CHAR(8)), 16, 1)

But the server doesn't like the syntax around '+'

What is the best way to do this?

Einar

UPDATE:
This works but is there another way:

DECLARE @einar nvarchar(50)
SET @einar = 'Error' + cast(@@error AS char(8))
RAISERROR (@einar, 16, 1)