[Zope] how to do stringmanipulation in SQL search templates

20 Jun 1999

      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