• My apologies to all .....

    1. I did test the code multiple times ...

    2. When testing the ; was NOT present.

    3. I can only guess, but was using a brand new lap top when submitting the question and typing the QOD rather than a cut and paste from SSMS, and somehow or other I pressed the semi-colon key.

    4. Poor excuse on my part for the error so let me say again:

    My apologies to all

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]