Concatenate two functions in a result I'm trying to add this as one of my columns:

REPLACE(REPLACE(REPLACE(dbo.new_truck.new_Description| CHAR(13)| '&lt;br&gt;')| CHAR(10)| '&lt;br&gt;')| '"'| 'in')+'Location: '+IF(dbo.new_truck.ditl_Inventory=True,'Vancouver','Edmonton')

But after executing the SELECT, SQL Server changes it to this:
REPLACE(REPLACE(REPLACE(dbo.new_truck.new_Description| CHAR(13)| '&lt;br&gt;')| CHAR(10)| '&lt;br&gt;')| '"'| 'in') + 'Location: ' + 'IF(dbo.new_truck.ditl_Inventory=True,[Edmonton],[Vancouver])'

It appears that I cannot concatenate a function with a string, with another function. If I take everything after "Location:" out, of course, it works. But without the location :)

Any other way to accomplish this? I could write this into the PHP code that handles the output of this query, but thought I'd try this first

Thanks for your help!
I have instead edited my PHP code that handles this data: 

//Show the location in the truck description 
if ($mainrow[24] == "0") { 
$mainrow[16] = $mainrow[16] . " Location: Edmonton"; 
} else if ($mainrow[24]=="1") { 
$mainrow[16] = $mainrow[16] . " Location: Vancouver"; 
} 

where $mainrow[24] is the "Inventory" column, and $mainrow[16] is the Description column.