Thanks Carlos, but it didn't work out, but I found something call it "containing", that do pretty much the same that like, and end it up like this:
where LUGAR_RESIDENCIA CONTAINING (:RESIDENCIA)
anyway, thank you for your time ;)On 10/27/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
Hello
Hello:
> I try what you told me using the @ before the variable, but I dont
> think that the query is actually viewing it as one, its more like
> another text for the like.
Ahh sorry i was understanding you were doing the call from the provider.
'%' || :RESIDENCIA || '%'
--
Carlos Guzmán Á
I try what you told me using the @ before the variable, but I dont
think that the query is actually viewing it as one, its more like
another text for the like.
For example, I try with @Residencia and :Residencia, and insert in the
table those like values, and it return some matches, but for the re
Hello:
> Excuse me, how do I use the statement "like", Im been looking in the
> web but can't find anything.
>
> I try to do something like
> select
> from
> where [Attribute] like ' % :NAME % '
>
> Assuming that the parameter :NAME is the input value, any help here please
Try using :
select
fr
Excuse me, how do I use the statement "like", Im been looking in the web but can't find anything.
I try to do something like
select
from
where [Attribute] like ' % :NAME % '
Assuming that the parameter :NAME is the input value, any help here please
-- "When you don't code, you tend to bec
