SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Find And Replace Abrreviations from Table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mach351C4V
Starting Member

1 Posts

Posted - 09/01/2011 :  13:25:41  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000