One of those oCmd.ExecuteNonQuery lines is commented out in the actual vbCode. I must have missed that when copying the code into the posting.

It turned out that a followup segement...

Thanks for your help.

I used the following method to return the score:

DECLARE @HOME1Score int
SET @HOME1Score = -1
SET @HOME1Score = 
(SELECT
   CASE
      WHEN  HOME1 < 7 THEN 3
      WHEN  HOME1 >...

That got me on the right track!

I modified it to the following:

DECLARE @mydate VARCHAR(10)

SET @mydate = '8/1/2003'

SELECT convert(dateTime,@mydate) - (DATEPART(DW, @mydate) -1) AS Sunday,

          convert(dateTime,@mydate) + (7 - (DATEPART(DW, @mydate)))...

Thanks ever so much! 

You've made my day.

John