function based index

since i have no 8.1 here, only 8.0.5, is this possible:?

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 - 05:33:50 CST