I have a table called Template containing two fields that I've defined with the following statement:

CREATE TABLE OrderTest
   (template int, template_name varchar(20))

The INSERT statements in Listing 1 show the kind of data this table contains. I need to display the result set so that it's sorted alphabetically by the template_name column, but the row that contains the data template_name = 'generic template' needs to come at the end of the list. How can I meet these criteria?

A Man...