[Zope] Help with SQL Like statement

[Mats Nordgren]

Hi again,

I have a question regarding the ZSQL methods.

How do you use LIKE in your sql statements?

ex:

SELECT *
FROM clients
WHERE last_name LIKE <dtml-sqlvar search_criteria type=string>%

the problem arises because the type automatically adds the ''
around the search_criteria and the percentage sign needs to be
inside the '' as in 'Smi%' for all accounts that start with Smi.

Thanks in advance.

--
Mats Nordgren
First Union Securities
mats@launchnet.com
icq: 14659299