Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Find And Replace Abrreviations from Table

Author  Topic 

Mach351C4V
Starting Member

1 Post

Posted - 2011-09-01 : 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.

Description
"With STOR Compartment; Power STR"

From To
STOR STORAGE
STOW STOWAGE
STPL STAPLE
STR STRIP

Output:
"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.

Thanks,
Dan
   

- Advertisement -