Why You Should Use & in SSRS Expressions
Posted by: Paul Litwins Blog,
on 22 Aug 2006 |
View original | Bookmarked: 0 time(s)
In SQL Server Reporting Services you can use the almost identical string concatenation operators: moe and curly, er. I mean + and &.Unlike in VB./vBA, the difference has nothing to do with Nulls since Nulls don't exist in SSRS textboxes (they are auto-converted into empty strings).The difference comes to the forefront if you try to concatenate a string with a number. Then the VB parser is not sure whether to mathematically add or concatenate and generates an exception.The moral of this post is...