Is there any way to create a reverse index on string columns so that
queries of the form:
where column like '%2345';
can use an index and perform as fast as searching with like '2345%'?
Is the only way to create a reverse function and create an index using
the reverse function and modify queries to use:
where reverse(column) like reverse('%2345') ?
thanks
--
Eugene Hart
Cell: 443-604-2679
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
