ive got an ASPX web page accessing an MS ACCESS backend.
i need to retrieve a list of books buy catagory in alphabetical order.
"....order by catagory ASC"
However some books do not belong to a catagory. therfore they appear at the top of the list b4 the "A"s.
i want them to appear at the end of the list, after the ZZZZZs.
is there an SQL ORDER command that puts blanks at the end of a ASC list????
im sure ive heard of this! but cant remember the command!
No i dont want to use DESC