title: mysql string concatenation returns 0
body: <p>im trying to concatenate 3 columns in a select query to show in one column in the results. the column is called DelPostalName and for some reason always shows a '0' when i run the select query. like its trying to add up the strings but theres not actual numbers to add. ive been googling string concatenation and this seems to be the correct syntax. any ideas?
  <pre>
  isc_orders.ordShipFirstName + ' ' + isc_orders.ordshiplastname + isc_orders.ordshipcompany as DelPostalName,
  </prE></p>