Posted - 09/01/2011 : 13:25:41
| Hi all! First post!
Using SQL Server 2005, what is the best procedure for replacing abbreviations in a table with the the UN-abbreviated version? I have a sql table that has abbreviations in it, and another table with the abbreviation(from) and the un-abbreviated version(to). I want to find the "From" and update it with the "To", looping through all the possible abbreviations for each line of text.
"With STOR Compartment; Power STR"
"With STORAGE Compartment; Power STRIP"
This will be run over thousands of rows of data, and each row checked against every possible abbreviation in the (from/to) table.
If there are any other threads you could point me to, it would be appreciated.