Powershell putting spaces bewteen string on database pull
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()