I am pulling some information from a database to first queury AD and its putting spaces in a string that I am pulling. In the Db I store a number as a string becuase to leading or ending zeros and then pull as a string and format as a string but my poweshell script is putting spaces in between teh numbers.
$Sql = "Select intUserId, strLogon, strEDIPI from iMAC_Users where bitUpdate = 1"
$cmd = New-Object system.data.sqlClient.sqlCommand($Sql, $conn)
$rdr = $cmd.ExecuteReader()
the id and same name are fin but the @Edipi should come out as a 10 number field such as
but it comes out as this
1 2 3 4 5 6 7 8 9 5