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