While working with one of the oracle query, when i am firing a select command with where condition something like:
select * from table_name where contains(address,'"IN%" AND "BÖDEN%"') >0
No results are shown as part of this query though results are there in database.
Again if i introduce one space between "IN" and "%" i am getting results in proper:
select * from table_name where contains(address,'"IN %" AND "BÖDEN%"') >0
There is one more scenario :
Same type of query but if "IN" is replaced with "IM" the corresponding results are displayed.
select * from table_name where contains(address,'"IM%" AND "BÖDEN%"') >0
or
select * from table_name where contains(address,'"IM %" AND "BÖDEN%"') >0
Both above queries are giving same results. which is quite obvious too.
Hence i suspect there is something speacial with "IN" in oracle.
Can anybody suggest me proper reason for this problem and any resolution for the problem ?