Thanks Grant!

There should only be a maximum of 10 results per query and it looks like it's much quicker than the Union in all the tests I've done so far....

I'd like to thank you all for taking the time to voice your opinions on this subject. It is much appreciated! This is by far the best forum I've ever...

My apologies - I have posted in the wrong section. I have SQL Server 2000, not 2005.

Thank you for your feedback!

Very interesting - much better it seems to work now so much appreciated. Thanks for the explanation - (a lot easier to comprehend than a code snippet)

So the reason...

I'm pretty sure it's defined properly in my include file - I put an OPTION EXPLICIT at the top of the asp page and still am having the same problem....

My apologies, the reason the code is doing nothing is because I don't have End Sub

Sub btnSave_OnClick

 dim TheForm,account,comment,revisedComment,fixComment

 Set TheForm = Document.forms("CommentForm")

 account = TheForm.accountNum

 comment = TheForm.skipComments

 revisedComment = Replace(comment,...

Here is my code - it is a .ASP page. The code comes from my test machine which isn't connected to the network (for testing reasons) so I retyped...

Thank you for the quick response but for some reason when I set it up this way, clicking the button does nothing.

I really don't understand the difference between <%...

I am customizing and modifying a program that my company has purchased. The only way to get to this page I have created is from a page that already contains...

Oh I see...that is a much better way to do that. I never thought of doing a response.write like that. It seems to be working how I want it to...

Thanks for the insight on that, I see what the problem is now. Not sure how I'm going to solve it though -

So I have my notes() array containing notes(0)...