Well Chris Porter, has just replied me with a smart solution but I can't test it right now until I get to work. I don't know why he can't post here.
this is the solution: select * from NODE_TABLE where '1.1.1.2.1' like id + '%' and id not like '1.1.1.2.1%' We are using OpenJPA and Oracle database. I am eager to check if it works well Thanks all ----- -- Regards Mohammad Norouzi Help each other to reach the future faster http://pixelshot.wordpress.com Pixelshot Photoblog http://brainable.blogspot.com Brainable Blog -- View this message in context: http://www.nabble.com/-URGENT--Incremental-matches%21-tp20577717p20606201.html Sent from the Cold Fusion - RegEx mailing list archive at Nabble.com. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/regex/message.cfm/messageid:1195 Subscription: http://www.houseoffusion.com/groups/regex/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.21
