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 ...

I want to set up a stored procedure where the data is ordered by column according to user input, i.e.GetSomeData(@SearchPhrase varchar(80), @SortCode int) ASSELECT Field1, Field2, Field3 FROM tbl ...

Note: It is recommended that you not include an ORDER BY clause in a CREATE VIEW statement. This causes the output data to be sorted every time the PROC SQL view is submitted and might have a negative ...

PROC SQL allows you to specify an alternate collating (sorting) sequence to be used when you specify the ORDER BY clause. See the description of the SORTSEQ= option in PROC SQL Statement for more ...

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.