|
Mach351C4V
Starting Member
1 Posts |
 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.
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  |
|
Find And Replace Abrreviations from Table
