- Last Active
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…