I really appreciate all the help too!!! :w00t:

steve,

When Importing the data via SSIS there are going to be random blank rows in the .dat files. When that happens it added leading spaces to the next line with...

sorry....it's not a report just returned in the results window at the bottom.

j-f ur right on the code comment but when I just query servername I get all rows back. (522,760)

I created this code but it still returns centered....aaaarrrrggggh!

I'm not sure if it matters but I used SSIS to import the data into my DB too...:w00t:

select distinct servername,

ltrim(servername)

as ServerName

from...

The thread doesnt show the leading spaces on the first two rows. I dont want to delete the records I just want the leading spaces out. The records should return...