lower function in SQL

Posted in 1997

Leszek Buczkowski — Mon, 08 Sep 1997 17:56:29 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, I write web-apps based on Netscape LiveWire and I am to deal with Informix now. It is ok but I find a problem - the following JavaScript expression with SQL query for case-insensitive searching... "select * from my_table where lower (name) = '" + searchtext.toLowerCase () + "'" ...works well in Oracle SQL but doesn't work in Informix. The problem is with "lower" function defined by Oracle but unknown for Informix. Is there any function that converts string to lower (or upper) case in Informix SQL? (There is no documentation about Informix SQL in Netscape SuitSpot). Leszek Buczkowski lb@ikp.pl