Search on exact phrase giving error everytime!

In our cart we are getting an error every time we click the option to "search on exact phrase" in the advanced search. It also doesn't give a specific reference ID either. Any other type of search in the advanced search works great. Any thoughts or ideas. Here is our advanced search page.

http://shop.rings-things.com/cart/pc/search.asp

Yes we just restored the original file before we edited it to removed [details] from the search and it still gave me an error using the "search by exact phrase" check box. Strange.... 

I restored showsearchresults.asp to it's vanilla state and I get results, but the query times out after showing all the results.

Our modified version of showsearchresults.asp instantly goes to techerr.asp but that is because the machine I built has a nuclear powered cpu and is fast.

Actually it errors to techerr.asp when you search, but I traced the code, and the error code is max int, 2million something.  Some reason the query is causing the error.  As soon as the query is executed, it errors.

Haven't gone much further than that.

Ugh..
Anyone see a problem with this SQL query?  This is where it breaks....it executes the query and errors with a max int value.

"SELECT TOP 200 A.idProduct, A.sku, A.description, A.price, A.listHidden, A.listPrice, A.serviceSpec, A.bToBPrice, A.smallImageUrl, A.noprices, A.stock, A.noStock, A.pcprod_HideBTOPrice, A.pcProd_BackOrder, A.FormQuantity, A.pcProd_BackOrder, A.pcProd_BTODefaultPrice, cast(A.sDesc as varchar(8000)) sDesc FROM products A  WHERE idProduct IN ( SELECT TOP 200 idProduct FROM categories_products, categories WHERE idProduct = A.idProduct AND ((A.serviceSpec<>0 AND A.pcProd_BTODefaultPrice>=0 And A.pcProd_BTODefaultPrice<=999999999) OR (A.serviceSpec=0 AND A.configOnly=0 AND A.price>=0 And A.price<=999999999)) AND A.active=-1 AND A.removed=0 AND categories.idCategory=categories_products.idCategory AND categories.iBTOhide=0 AND categories.pccats_RetailHide=0 AND idSupplier=10 AND (stock>0 OR noStock<>0) AND ((((content1 LIKE 'blue bead') OR (content2 LIKE 'blue bead') OR (content3 LIKE 'blue bead')) OR ((content1 LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%') OR (content2 LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%') OR (content3 LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%')) OR ((content1 LIKE 'blue bead[^a-zA-z0-9]%') OR (content2 LIKE 'blue bead[^a-zA-z0-9]%') OR (content3 LIKE 'blue bead[^a-zA-z0-9]%')) OR ((content1 LIKE '%[^a-zA-z0-9]blue bead') OR (content2 LIKE '%[^a-zA-z0-9]blue bead') OR (content3 LIKE '%[^a-zA-z0-9]blue bead'))) OR ((A.description LIKE 'blue bead' OR  A.description LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%' OR  A.description LIKE 'blue bead[^a-zA-z0-9]%' OR  A.description LIKE '%[^a-zA-z0-9]blue bead') OR (A.sDesc LIKE 'blue bead' OR  A.sDesc LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%' OR  A.sDesc LIKE 'blue bead[^a-zA-z0-9]%' OR  A.sDesc LIKE '%[^a-zA-z0-9]blue bead') OR (SKU LIKE 'blue bead' OR  SKU LIKE '%[^a-zA-z0-9]blue bead[^a-zA-z0-9]%' OR  SKU LIKE 'blue bead[^a-zA-z0-9]%' OR  SKU LIKE '%[^a-zA-z0-9]blue bead'))) ORDER BY A.sku ASC, A.idproduct DESC"

Edited by ricardoc - 26-June-2008 at 6:57pm

Note: Anyone using a Beta or pre-release should report the issue back to the support agent that provided the files.  You will get the fastest support that way.