<< Since they are long text names, should I still index them? I just changed the WHERE to use LIKE instead of CONTAINS. It is hard to tell from here (off site) but it seems faster. >>
CONTAINS will never use an index, so if this search is the only reason you're indexing the columns you can safely remove the indexes. If you want an indexed search, you must use LIKE and make sure that there is no wildcard at the beginning of the string. -- Larry >
