Re: function based index

is this possible in 8.1?:

create index idx on table(substr(field, 1, 1));

and then use the select:

select * from table where substr(field, 1, 1) = 'X'; Received on Fri Dec 13 2002 - 09:41:08 CST