I have a problem When i insert data into a field of same length, when i select the results in grid view they are not align correctly but when i select results to text they are a well aligned.
what could be causing this and how can i get them corrrectly aligned?
the kind of data am inserting are like 'Personal Account 20,000.00' They are are all of lenght of 55.
see sample below
SQL 2005 & 2008