Blue Ridge Software LLC
  Encryption
Services
  Webmaster
Services
  Programming   Software   About Us

Program Snippets

  SQL 2000 - Apply a Custom Sort Order (Add To Favorites)
id       | name
--------------------
1        | George
2        | Yuki
3        | Bob
4        | Fred
5        | Henry
6        | Rita

The client wants all the women's name first. What to do? 
If you do not have a sex indicator, try this custom sort:

SELECT
    id
  , name
, FIND_IN_SET(name, '6,2,3,4,1,5') as sort_column
FROM names
ORDER BY sort_column;
© 2013- Blue Ridge Software LLC