I am writing a query that will concatinate 4 field in SSRS SQL builder. I keep getting an error on the " & " (ampersand).
Any help is appreciated on how to concatinate the following fields and put spaces in between each field.
MyTable.HOUSE_DIRECTION & " " &
MyTable.STREET_NAME & " " &
MyTable.STREET_MODE & " " &