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.
Ah, crud. I totally misread the original post. My apologies.
--Jeff Moden
Change is inevitable... Change for the better is not.