Basic SQL question

[jda]

>
>Because in the ASCII table, the capitals come before non-capitals  
>asc(72)=H; asc(97)=a
>
>Not sure but try:
>
>SELECT * FROM table ORDER by UPPER(name)   ????
>

I don't think that will work (but try). I use a method that does the 
same thing (VText field, you should change this to VString or 
VVarChar, or whatever you use):

  nameSortMethod = new VText("nameSortMethod", 128, "English", kV_Indexed)
  nameSortMethod ("Upper(names)")

In the SQL query I

SELECT * FROM table ORDER BY nameSortMethod

Jon