HELP: Case Sensitive ordering in SELECT

Sunil, Yo asked: >As farI tried tp post this article last week, but was unsuccessful >in doing so. >I want to write a SELECT statement using ORDER BY textcolumn. >The results I get give me case sensitive sorting i.e. Z is less than a. >How can I get the results sorted irrespective of the case? >I am using Informix 5.02 UC6 on SunOS 4.1.3. >Please copy the repolies to nariani@teachersoft.com >-Sunil >-- >--------------------------------------------------------------------------- --- >Sunil Nariani nariani@teachersoft.com >TeacherSoft Inc. Home: >903 E 18th Street 3700 Preston Rd, # 1325 >Suite 230, Plano TX 75074. Plano TX 75093 >Ph: (214) 424 7882 x305 Ph: (214) 596 0093 >Fax: (214) 424 5503 >--------------------------------------------------------------------------- --- The answer is, I don't think you can. You would need to be able to convert the case of the data as it is read by the select statement. I cannot think of an extended feature in Informix SQL that allows you to do this. If you have informix 4GL available, you could write a program to do it. On a unix system you could unload the data to a file and use the sort command. I bet none of this is really much help to you though. Mark Denham BBC London, UK Mark.Denham@bbc.co.uk