SQL_NuB (3/4/2015)
Jeff Moden (3/4/2015)
What's wrong with just doing a replacement?
UPDATE tgt
SET Family = REPLACE(Family,'--','')
FROM dbo.yourtable
WHERE Family LIKE '%--%'
;
there are other apps using the tables that I'm pulling from, so we can't do an update. It crossed my mind, but can't.
Yeah, I'd be extremely careful before just arbitrarily discarding potential delimiters in a column value.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.