how to get an array based on a column of a database resultset

the item in products 1,2,3..etc

, need string "1,2,3..", used following command, returns ,,,,,,,,.

$result=invoke-sqlcmd -serverinstance $databaseservername -database $databasename -query 'select item products"

($result|select item) -join ','

no need use join. here's couple of ways of doing changing code:

  $result=invoke-sqlcmd -serverinstance $databaseservername -database $databasename -query 'select item from products" | foreach {$_.item}

  $result=invoke-sqlcmd -serverinstance $databaseservername -database $databasename -query 'select item from products" | select -expandproperty item

Windows Server > Windows PowerShell

Bit