RE: Need Help with UPPER function in Informix V7.24

Parupalli Venkata noted: > Following query works fine in v7.31 but not in > v7.24 because the UPPER function is not in v7.24. > > SELECT * FROM BORROWER WHERE UPPER(LAST_NAME) => 'BROWN' In order to make this work in v7.24 you have to create your own UPPER function. Before you migrate from 7.24 to 7.31, you must drop it, though, or you will get errors. There are some SPL samples in the group's history you can find through a Google search, or you can search the http://www.iiug.org/ software archives. By the way, this may be the nicest response you get on this group. I encourage you to do a little research with the above resources before posting again if you feel some of the locals are too rough on you. Sincerely, Christopher Coleman Steering Committee President Kansas City Informix Users Group www.iiug.org/kciug Database Analyst Pharmacy Division Mediware Information Systems, Inc.