Re: Converting Oracle function UPPER

Posted in 1997

Curt Mayers, Consultant — Tue, 11 Feb 1997 17:21:03 -0800 — source: Informix-list mailing list archive (1991-1998)

Lin-Chuan Lee wrote: > > Anyone with advice on converting Oracle functions > in general and the upper function in particular. > > Need to convert VB application with Oracle backend to Informix. > > TIA- > Lin Believe it or not: Create a dummy table with no rows. (for this example, "dummy"). Then you can create a function (or SQL statement) that goes along these lines select upshift(this_string) from dummy; Kludgy, yes. It works