Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  sort dataview column and blank values

Author  Topic  bbqn Starting Member 1 Post Posted - 2006-02-02 : 11:30:12 In my datagrid I link it to a dataview of a table. The dataview is sorted on a column that may contain blank spaces. When I sort on this column, the rows with blanks spaces are listed first. Is there a simple way I can have those rows with blank spaces at the end. Here's some code: dg.DataSource = dv dv.Sort = "TagColumn" Result display: " " " " "5a" "9f" etc Expected result should be: "5a" "9f" " " " "