RE: PLEASE HELP ****** Stripping #s from one column to update 2 columns *******

Alan Burstein

SSC Guru

Points: 61136

September 27, 2016 at 6:10 pm

#1903529

I have no idea what you're trying to do but it seams simple. Please post your desired results. On a side note -

This:

and (cm.Original like'6%' or cm.Original like '7%' or cm.Original like '8%' )

..could be replaced with:

and (cm.Original like '[6-8]%')

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001