try this: select * from annunci where testo like '<dtml-var "'%' + firstword + '%'">' and testto like '<dtml-var "'%' + secondword + '%'">' cheers jim cesare@planningsrl.it wrote:

Hi all!

I would like to do a form in which the user can edit few words (separated by a blank character).

When the user press the "Search" button I would like to use those words to search in a field of a table.

I have done it but I have two problems:

1) I use sqlgroup but I can use it just with the = and not with the LIKE statement select * from annunci <dtml-sqlgroup where> <dtml-sqltest Parola column=testo type=string optional> </dtml-sqlgroup>

the result is:

select * from annunci where Parola="Word"

but I would like this result:

select * from annunci where Parola LIKE "%Word%"

2) I am not able to divide the words in more conditions. I would like the following result: select * from annunci where testo LIKE "%FirstWord%" and testo LIKE "%SecondWord%"