However, the replace() function in WSQL Server 2000 is a little wierd in this case as you think you should be able to do replace(@string,','') but you can't It doesn't work.