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 :your_parameter + "%"

|||

Or, if using native Oracle vs. OLE/DB:

Where ID Like :your_parameter || '%'

Hope this helps,

Don Shelman

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.
>