If I am not in the correct newsgroup, my apologies, I wasn't sure if this
was a sql question or an aspnet question.
Is there a way to sort data, like from a sql query, so that a selected
column is alphabetized but the nulls or blank fields are listed last? Or
any idea how I would do this?
I have a query -- select lastname, firstname, address, county -- that I want
to sort by county and display in a datagrid, but those entries without a
county listed I do not want at the top of the list. Any easy way to do this
other than get a list of counties first, then query each county separately?
And if I were to run a separate query for each county, how would I attach
each result to the datagrid?
Thanks for your help.