I am receiving the following errors on creating an index using lower() on a varchar field db1=> create index fieldindexlower on table1(lower(fieldvalue) varchar_ops); ERROR: BuildFuncTupleDesc: function 'lower(varchar)' does not exist Do I need to convert the field to "text" or are there other options ? Thanks, Vince ************