Powershell putting spaces bewteen string on database pull

kdeutsch
kdeutsch used Ask the Experts™
on
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()


While($rdr.read())
    {
        $UserId =($rdr["intUserId"].tostring())
        $Sam =($rdr["strLogon"].tostring())
        $Edipi =($rdr["strEdipi"].tostring())
    }
$conn.close()


Write-Host $UserId
Write-Host $Sam
Write-host @Edipi

the id and same name are fin but the @Edipi should come out as a 10 number field such as
1234567895

but it comes out as this
1 2 3 4 5 6  7 8 9 5
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Did you by any chance define the field as being nvarchar? The output looks like Unicode encoded and displayed as char array, with each second byte being zero.

Author

Commented:
Hi,
Nope in the sql db its a Varchar(10), never use nvarchar at all.
"Batchelor", Developer and EE Topic Advisor
Top Expert 2015
Commented:
Write-host @Edipi     isn't a typo? It should be
Write-host $Edipi

Author

Commented:
ok wow,
need to go home and start gaming.
Thanks

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial