|
you need to play around with the replace and length function: VALUES (len("Alpenbock/Gelbbauchunke/Hohltaube/Mittelspecht/Rotmilan/Spanische Fahne") - len(replace("Alpenbock/Gelbbauchunke/Hohltaube/Mittelspecht/Rotmilan/Spanische Fahne","/",""))) now, I'm not using a column, I just force-fed it the string. But, here you see we are getting the length of the original string, and subtracting the new string when we replace all occurrences of "/" with "". It's just a little sleight-of-hand. Again, Manifold 8 for the win!!! :-)
|