[Zope] Query

[Dugas, Rheal]

HI all
I am a color specialist with Xerox. What i am doing with Zope is setting up
a Knowedge database for my fellow color specialist. I am having a bit of a
problem setting up a search query. Following is what i have know, Could
somebody tell me how i could improve on this query.

SELECT * FROM problems WHERE

problems_rip_model LIKE <!--#sqlvar dfe type=string optional-->
OR
problems.prob_descript LIKE '%<!--#var Problems-->%'
OR
problems.prob_solution LIKE '%<!--#var Problems-->%'

Is this the proper code or is there a better way of doing it?

Thank You
Rheal J. Dugas
1-800-939-3769 ext 1074