Inserting Records and using LIKE

steffler · Post by **steffler** » Wed Oct 08, 2003 3:44 pm

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.

Post by **mark** » Wed Oct 08, 2003 4:50 pm

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?