Hi,

I am getting wrong results from an oracle text query.

SELECT COUNT(*) FROM dwh_dist_item
WHERE pack_info LIKE '%#2.5%'

COUNT(*)
--------
566


SELECT COUNT(*) FROM dwh_dist_item
WHERE CATSEARCH (pack_info, '%#2.5%', NULL) > 0;

COUNT(*)
--------
24854

Why is the second query returning more rows than 1st query ? Is # a
special character ?

Thanks
Preet