title: Concatenate Properties from a System.Data.DataRow object in powershell
body: <p>I have stored the results of an sql server query in a variable named $TESTER using the Invoke-Sqlcmd cmdlet. </p>
  
  <p>I want to take the fields from each row (i.e. name, address etc) and concatenate them into a seperate string parameter named $STR </p>
  
  <p>something similar to the below</p>
  
  <p><strong>$TESTER | Select-Object | ForEach-Object {$STR = $<em>.name + $</em>.address + $_.postcode}</strong></p>
  
  <p>Any ideas?</p>