is it possible to create an index using substr ?
say for example i have a field called num which has char(8) as its datatype and length.
an example of num's value would be something like 09092010
now what i want is to create an index using the last 4 characters of num's value which is 2010 in my example.
would it be possible to do it?