Sorting issue on a String column

Good morning everyone, I’m having issues when sorting a ‘Name’ column (String) as shown in the below screen shot, the sort is in Ascending order. As we see the data below, the highlighted 2 records are displaying in the 3rd and 4th rows, and in fact those 2 records are supposed to be in 4th and 5th rows, also the 5th record supposed be in 3rd row.  Please share anyone has any idea on what's going on here or how to fix this. Thanks, Venu      
1 answers

It appears the sort is ignoring the spaces embedded in your string.  Where is this happening?  In a datagrid?  Or somewhere else?