Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
readme.txt | 2020-05-11 | 870 Bytes | |
upper_spl.sql | 2020-05-11 | 8.2 kB | |
Totals: 2 Items | 9.1 kB | 0 |
Subject: SQL/INFORMIX (UPPER) Newsgroups: comp.databases.informix From: "Mark D. Stock" <marks@west.co.za> Date: Thu, 17 Apr 1997 17:06:38 +0200 > My request is : > SELECT ROWID FROM EMP WHERE UPPER(FIRST_NAME)=UPPER('Tyler') > UPPER is a ORACLE/SQL+ function. > INFORMIX error is : > 674: Procedure (upper) not found. > 111: ISAM error: no record found. > Can you tell if UPPER or same function exist on INFORMIX. You need to create the upper function like so: Example of usage: select * from sometable where upper(name) = "NAOMI" ---------------------------------------------------------------------- John H. Frantz Power-4gl: Extending Informix-4gl frantz@centrum.is http://www.rl.is/~john/pow4gl.html -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet