I want to replace the contents of a specific column with something else, regardless of what the original data in that column was. How can I do this with the replace() function in TSQL? Is tehre some ...

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then ...