November 28, 2011 at 1:14 pm
Hi,
I have a table with many columns. It contains the details of the products.
One of the column is product description.
For example..
ITEMNMBR DESCRIPTION
JC463 Tropicana juice " 24 oz
I want to replace the " with a '+' sign...
Like that there are 100's of products like that...
So I need any script which I can run against the table.
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
November 28, 2011 at 1:36 pm
update [table_name] set [column_name] = REPLACE([column_name], '"', '+')
November 28, 2011 at 1:41 pm
I should stress the fact that this will absolutely replace every occurance of the 1st character with 2nd character everywhere it exists in that column. So if that's not exactly what you want to have happen, then don't execute the script. Proper testing should prevail in all cases of data modification and you should backup and restore to a lower environment to test your scenario. At the very least, create a new database in a lower environment and import the data from just this table and test your changes.
November 28, 2011 at 1:48 pm
Richard Moore-400646 (11/28/2011)
I should stress the fact that this will absolutely replace every occurance of the 1st character with 2nd character everywhere it exists in that column. So if that's not exactly what you want to have happen, then don't execute the script. Proper testing should prevail in all cases of data modification and you should backup and restore to a lower environment to test your scenario. At the very least, create a new database in a lower environment and import the data from just this table and test your changes.
Wow, great disclaimer! Are you a consultant, by any chance? 😀
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
November 28, 2011 at 1:54 pm
Richard Moore-400646 (11/28/2011)
I should stress the fact that this will absolutely replace every occurance of the 1st character with 2nd character everywhere it exists in that column. So if that's not exactly what you want to have happen, then don't execute the script. Proper testing should prevail in all cases of data modification and you should backup and restore to a lower environment to test your scenario. At the very least, create a new database in a lower environment and import the data from just this table and test your changes.
thanks dude,
Yes, I will be checking this script on some products in a dev environment and make sure the application/software is catching it right as we need it.
Regards,
Skybvi
Regards
Sushant Kumar
MCTS,MCP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply