I had already tried that. That's when I got an error saying, "Incorrect syntax near the keyword 'SELECT'." So I wasn't sure if it was right. What about the syntax...

Thanks for the replies

I tried the example from Books Online. It would create my new column but wouldn't put anything in there.

Jack...I can't seem to get rid of an error...

Actually we are using 2k5 but I don't think it makes a difference on this.

Sorry for the long code but its shorter than me trying to describe it. I am getting an error saying incorrect syntax near ",". The only comma in the string...