Received: from out1.ibm.net (out1.ibm.net [165.87.194.252]) by hub.org (8.9.1/8.9.1) with ESMTP id UAA01503 for ; Tue, 10 Nov 1998 20:20:23 -0500 (EST) (envelope-from pierre@desertmoon.com) Received: from [129.37.120.87] (slip129-37-120-87.mo.us.ibm.net [129.37.120.87]) by out1.ibm.net (8.8.5/8.6.9) with SMTP id BAA68486 for ; Wed, 11 Nov 1998 01:20:20 GMT Message-Id: <199811110120.BAA68486@out1.ibm.net> Subject: Using lower in create index Date: Tue, 10 Nov 1998 19:20:32 -0600 x-mailer: Claris Emailer 2.0v3, January 22, 1998 From: pierre To: Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" I've been trying to create an index on a varchar field and I've tried using the following to create the index. create table subject ( name varchar(85) ); create index subject_idx on subject using btree(lower(name) text_ops); Gives me an error that the function lower(varchar) doesn't exist. I've tried placing a text(name) to force the arg to a text value, but get a syntax error. Anyone have Ideas on creating a lowercase index on a field that isn't always lowercase? Pierre