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.
| 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 ToSTOR STORAGESTOW STOWAGESTPL STAPLESTR STRIPOutput:"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