Datagrid Sorting Question - Deal With Empty Cells

[rhungund]

Hi All. I'm using VB.net in a webform with a datagrid. I need to sort
by column name which is working fine, but i need any row with an empty
result for the sorted column to show up at the end my resultset, not
the beginning. Any ideas??

so instead of: NULL A-Z

I need: A-Z NULL



thanks.

-RH

 

[Elton Wang]

Hi,

Suppose in field Note there are some Null and empty
values, think about following query:

Select EmployeeID, EmployeeName, Note from Employee
order by (Case When Note is Null Then 'zzzzzzz' When Note
='' Then 'zzzzzza' Else Note End)

HTH,

Elton Wang
(e-mail address removed)