Sort Database Field Partially

Question

Hi,


I need to sort a field "name" of that contains some name, NULL and few blank records. Some how i need to sort them by arranging all the name in alphabetical sort order at the top and after that all rows containing NULL should come and after that all rows containing blank should come.


Thanks