Home Forums SQL Server 2005 SQL Server 2005 General Discussion Multiple replace on 1 column in select statement. RE: Multiple replace on 1 column in select statement.
Mike Menser
Hall of Fame
Points: 3679
More actions
October 1, 2009 at 7:31 am
#1060424
Nevermind. Had a senior moment (which is weird since I am only 26). I just went with:
replace(replace(new_header,'#firstname#',firstname),'#lastname',lastname)
And added the replace statements for all of my string, and it seemed to work. 😛