So in dataflex, I might write this:

Code:
String sValue
move ('Case #: '+(string(Cases.Number))+'   Status: '+sStatWord) to sValue
I am trying to do that in SQL, and the Codesense in the SQL Console is indicating an error. I am trying:

Code:
DECLARE @sValue nVarChar(40);
DECLARE @sStatWord nVarChar(40);

@sValue = 'Case #: ' + cast([CASES].[NUMBER] as varchar) + '  Status: ' + @sStatWord
It seems to not like the very first "+" sign.

Can anybody show an example of how to append together a string and a number to form a new string.

Not sure what I am missing

TIA

Mike