Here's for six letters.  It returns Bertha.  To do for five letters would follow a similar pattern.

DECLARE @six_letters NVARCHAR(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie,...

• This reply was modified 5 years, 3 months ago by Steve Collins.
• This reply was modified 5 years, 3 months ago by Steve Collins.

DECLARE @six_letters NVARCHAR(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie, yuppie, rabble, tallow, brooks, tassel, meddle, callus, peddle, sobbed, kneels, getter, brooms, dulled, maggot, webbed' ...

• This reply was modified 5 years, 3 months ago by Steve Collins.
• This reply was modified 5 years, 3 months ago by Steve Collins.
• This reply was modified 5 years, 3 months ago by Steve Collins.

Maybe have a look at this other thread where something similar was discussed.

https://www.sqlservercentral.com/forums/topic/ignoring-error-and-continue/page/2/#post-3765149

Not the connecting using openrowset but the loop and the error and continue

That's what I should've done.  My Asus laptop with a 17" screen weighs like...

Since this was written I've been on this trying to make it happen.  Wow, 3 months ago...

What I dislike about PIVOT is that you have to repeat UNIONs several times depending on the metric. This makes it difficult to change and error-prone as you may...

Frank's answer above removes the reference to the CODE_CHARGECREDIT table and removes c.PEOPLE_ORG_ID (which is non-existent) from the GROUP BY.  Idk if that makes sense.  Fixing the (many) errors and...

Horses for courses and everybody thinks their way is the best.  Why not have a sense of humor about it?  I agree Pivot and Unpivot are kludge compared to conditional...

Idk why don't you give it a try and let us know

... since I write SQL now not a...

Ha I think's the other way around.  CASE WHEN is an abomination of over wordiness that never should've been created.  First, back in the day you used to have to...

Imo IIF gets hated on because it was available first in MS Access.  IIF gets interpreted back to "CASE WHEN" so it's really the same (which is a shame because...

It also works without the tally table and just using CROSS APPLY

select
  po.ProductCategory, po.ProductSubCategory, v.Region, v.OrdersPlaced,
  (v.OrdersPlaced*100.0/SUM(v.OrdersPlaced) over (partition by po.ProductCategory)) PercentPlaced
from #po po
 ...

Both work.  The tally based is probably more efficient depending on scale.  It didn't occur to use a tally table...

Ok ok I changed the decode to 'South Africa' and now it does work.  Misdiagnosed due to misleading code?  Yea, if it scans once and there's no dependency then it...

Wait a sec.  North Africa is in the code twice!