Re: UPSHIFT Function?

In article <49na58$l80@cssun.mathcs.emory.edu>, CRAIG@CHEMISTRY.CHEM.UTAH.EDU wrote: > Dean, > > Informix's 4GL has an upshift function but there isn't one in SQL. > You could probably write an upshift stored procedure which could then > be used in an SQL statement. But, I think you best approach would be > to perform the upshift in your host language. What is it you're trying > to accomplish? > > --Craig (craig@chemistry.utah.edu) > > >Can anybody tell me if there is an UPSHIFT function for Informix. I spoke > >to Informix Technical Support who said there is but couldn't give me the > >syntax or where to find it in the manual (Really helpful). For 99% of stuff you can do that, but there is one case where you can't... In particular, joining two tables, with you criteria being a comparison of a (for example) userid field in each table. One table has the data in all uppercase, the other table has the data in mixed case. -- Nathan ------------------------------------------------------------------ Nathan Neulinger Univ. of Missouri - Rolla EMail: nneul@umr.edu Computer Center WWW: http://www.umr.edu/~nneul SysAdmin: pluto.cc.umr.edu WWW: http://pluto.cc.umr.edu SysAdmin: rollanet.org ------------------------------------------------------------------ These opinions are my own. I do not speak for Computing Services.