OK, I need to convert a Number to a String so I can concatenate two fields together.
See attached screen shot
I need to convert the Site Number from Int to String so I can do something like this:
SiteNumber + ' - ' + SiteName AS DisplayName
But it won't let me because SiteNumber is a Int and is trying to add it to my dash.
I need something like CAST or CONVERT like used in SQL.