Ars Technica

SQL: an ORDER BY clause that will filter out "a" "an" and "the"

So I wanna sort something like "The Who" or "The Grateful Dead" by 'W' and 'G', respecively. How does one accomplish this? I tried using a function in the ORDER BY clause, but SQL syntax doesnt seem ...
Ars Technica

Dynamic SQL 'ORDER BY' clause

I want to set up a stored procedure where the data is ordered by column according to user input, i.e.<pre class="ip-ubbcode-code-pre">GetSomeData(@SearchPhrase ...
TechRepublic

10 tips for sorting, grouping, and summarizing SQL data

This article is also available as a PDF download. Arranging data in a manner that’s meaningful can be a challenge. Sometimes all you need is a simple sort. Often, you need more–you need groups you can ...
TechRepublic

SQL basics: SELECT statement options

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...