Thunderstone Support Forums

If you're creating a table that will have to use LIKE in the WHERE clause what are the steps to make it happen?

So far I've created the table and added a METAMORPH INDEX to it but it still won't do LIKE queries.

The field you're going to do a like on should be varchar. Create a metamorph inverted index on the field you're going to query. Perform a like against the same field you created the index on.

What's your query?
Using tsql or vortex?
In vortex, what errors do you get in html comments on the results page when you try your query?