LukeLT Member

Comments

  • Here's what I get when I run the that additional code. It's the "Club Description New" column. Tried tweaking a few things in the case to be <> 0 as well and still returning either the "club description" or "club description new" values.
  • It appears that Workbench is reading charindex and substring individually, but when you combine the two together it is having issues. Here's the query I ran - took @jaeW_at_Onyx's version and added one for substring. SELECT DISTINCT MarketingClubLevel, -- is my query identifying the space? CHARINDEX('…
  • SELECT DISTINCT MarketingClubLevel, CASE WHEN CHARINDEX(' ',MarketingClubLevel,1) = 0 THEN MarketingClubLevel ELSE SUBSTRING(MarketingClubLevel,1,(CHARINDEX(' ',MarketingClubLevel,1))) END AS ClubDescription FROM vClub Result in SSMS: Result in Workbench: Not necessarily getting an error, but as you can see as an example…