[Zope] how to do stringmanipulation in SQL search templates

[Joachim Schmitz]

Hi,

I try to accomplish a very simple thing:

the select statement shall finally look like this:

select * from data where name LIKE 'Ab%'

As input in form the user should only give "Ab" and the "%" should be
added by default.

I tried:

select * from data where name LIKE <!--#var expr="name + ´%´" sql_quote-->

but that gives a 

     name + ´%´
            ^
 SyntaxError: invalid syntax

Any help is welcome


Joachim Schmitz