I have a text in the following format
and I would like to select only the text between the first two forward slashes i.e. (xxx)
how do I do that in SQL query
I have been trying to use
select substring (column,CHARINDEX('/',column)
,CHARINDEX('/',column)+len(column) - CHARINDEX('/',reverse(column))) as ColumnName
but that returns /xxx/yyy/zzz and NOT /xxx/
Thank you for your help in advanced !