shailesh mali wrote:

> I want to use these wildcards in my stored procedure block as follows
>
> Select * from your_table where your_field Like '%Some_variable%';
>
> it is not working...Please help me out

You need to add the %'s *TO* Some_variable before using it.
Having said that - have you tried
'%' || Some_variable || '%'
Some how I think it should work - but stand to be corrected - I process
the Some_variable in PHP before I send it ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services