Any Alternative to LIKE operator ???
SHUBHJun 13 2006 — edited Jun 13 2006I have a query
I need to search a table on the basis of first name and lastname in a table x.
Both the cols are indexed .
now the query is somewhat like
select sysdate,empid,bonus from x where firstname like 's%' and lastname like 'w%';
Can i write the query in a diff way without using any other operator ? ( eg between etc).
I am using oracle 9i .