----select characters before / including /

select SUBSTRING ('abcde/wxyz',0,CHARINDEX('/','abcde/wxyz')+1)

I'm confused with the code above. Isn't the position of the first character of a string always = 1 ?

I ran these queries:

SELECT...