Casey Crookston noted: >>Yes. Like I say, the exact same query in Query Analyzer takes 0 to 1 seconds to complete. Hi Casey, I would check on the 'exact same' assumption by printing out the query from the webpage just before it executes. Sometimes a small variable spelling error or something can cause the value being sent to the db to be undefined (and hang) when *I* think it's sending a numeric "42" ... Or a character '42' when I think its sending numeric ... Etc. Or special characters get embedded when I'm not expecting them. Good Luck, RonL.