Reverse table

[siropchik]

Help,help!!!

Hi,I have very strange problem .My big table consists of many records ,part of them is null or empty value .Now a problem:
Then I do Order By 'Some Column_Name' I receive an answer but in wrong way :First of all -it's a empty fields and at finish Results that i need.
Probably you know how can I redirect an answer.
First my search value,after empty fields????
I wrote a query :
SELECT * FROM Table_name WHERE column_name not like '' order by column_name
It works good, but I lost an empty fields.(this query prints only non empty fields ,but I have to receive empty fields AFTER not empty )
Thanks

[eriksmoen]

try

SELECT * FROM Table_name WHERE column_name not like '' order by column_name ASC

or

SELECT * FROM Table_name WHERE column_name not like '' order by column_name DESC