[Zope] SQL queries with LIKE???? (Am I to dumb?)

[Oliver Andrich]

Hi,

I like to create a SQL Method that does a query like

select * 
from account_info
where account like "%foobar%"

But I only get equality tests or a query that looks like that

select *
from account_info
where account like "%'foobar'%"

I think, that this is easy but I can't see the solution for this?

Thanks,

    Oliver

-- 
Oliver Andrich, RZ-Online, Schlossstrasse Str. 42, D-56068 Koblenz
Telefon: +49-261-39210-40 Fax: -33 |       http://rhein-zeitung.de 
                                   |            http://andrich.net
GMC d- s++:++ a- C++ UL++++ P-- L+++ E--- W++ N+ w-- O- M-- 
V- PS++ PE Y+ PGP+ t 5+ X R+ tv+ b++ DI++ D- G e h- r z+