Hi All,

I am using REGEXP_LIKE instead of Like as my comparasion data is saved in one table. 
And i am passing values in stored procedure and check if it matches pattern in the table.

For eg. 
Table can have data
abc
*abc*
abc*
*abc
*a*b*c*

In Stored procedure i will be passing values 'xaybzc' and i will check if this pattern is present in table.

But problem is i am not getting desirable result.

   	LIKE                          				REGEXP_LIKE
1.abc : 'xaybzc'like 'abc'      			^abc$ : regexp_like('xaybzc',^abc$)
2.%abc% : 'xaybzc'like '%abc%'  	 	abc : regexp_like('xaybzc',abc)
3.abc% : 'xaybzc'like 'abc%'    			abc* : regexp_like('xaybzc',^abc*) [/B][/B][/COLOR]
4.%abc : 'xaybzc'like '%abc'  			*abc : regexp_like('xaybzc',*abc$)[/B][/COLOR]
5.%a%b%c% : 'xaybzc'like '%a%b%c%'  	*a*b*c : regexp_like('xaybzc',*a*b*c*)[/B][/COLOR]

Steps 3 to 5 are not working properly. Could any one give me correct way to compare this kind of pattern.

Regards
Manish