KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
My SQL looks something like this: SELECT CompanyName , LastName , FirstName FROM ... JOIN ... ORDER BY CompanyName , LastName , FirstName Now the problem is that column A is sometimes empty (either as NULL or "" ), and I don't want all those results to turn up in the end. In the example, I'd like to have the fourth entry (which starts with a C) to be the third. But if I just ORDER BY, this happens: Avagax Bauer Frank Bele AG Smith John Mork AG Baggins Frodo Chen Jun In addition, I sometimes have more order-by columns in a few cases, either more or less important. This might be relevant. Addendums: Either last name or company must have a useful string. First name is completely optional. The system is PostgreSQL (8.4, might migrate to 9), and also SQLite. Vendor-independence would be a plus, because there are potential customers already running Oracle and SQLServer.
Tags (comma-separated)
Save Edits
Cancel