I have a table of skills. In that table, are rows of data with various skill type. I need to return a list of those skills in alphabetical order, with one exception. The skills "General" can't be listed in the "G's", instead, it needs to be the last item. (Crazy, I know, but it's to discourage users from settling on a selection of "General".
This statement returns all the skills in alphabetical order, but "General" is listed right in the middle with other "G's:SELECT SkillsID, Skill, SkillDesc FROM tSkills ORDER BY Skill
View Complete Post