Home Forums SQL Server 7,2000 SQL Server Newbies extracting column values when a part of the column value is known RE: extracting column values when a part of the column value is known
Ed Wagner
SSC Guru
Points: 287026
More actions
August 22, 2014 at 11:33 am
#1740358
Using the REPLACE function is the simplest way to do it. Assuming there aren't any unusual requirements, that's exactly the way I'd do it.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions