Order By!!!


#1

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???
Thanks


#2

ORDER BY column ASC
or
ORDER BY column DESC