How to use parameter with LIKE?

Hello.
I have a query that ends like this:
WHERE ID LIKE '12345%'
I want to replace the '12345' with a parameter name p_id.
If I'm useing only p_id without the % it ok but if I'm useing the %
after the parameter I'm getting an error.
I'm working ORACLE database.
Any ideas?
Thanks in advance,
Roy.try this
="where id like '" & p_id & "%'"
"nicknack" wrote:
> Hello.
> I have a query that ends like this:
> WHERE ID LIKE '12345%'
> I want to replace the '12345' with a parameter name p_id.
> If I'm useing only p_id without the % it ok but if I'm useing the %
> after the parameter I'm getting an error.
> I'm working ORACLE database.
> Any ideas?
> Thanks in advance,
> Roy.
>