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:
> 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 Álvarez
Vigo-Spain

http://carlosga.wordpress.com

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



--
"When you don't code, you tend to become one of those architects who thinks everything is possible" (Anders Hejlsberg )
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to