I have string value as follow.
I would like to know the expression to remove after /
so string will be just
However, I can't use string length for this because some time I will have
4 digits instead of 5 digits.
Is there an expression to remove everything after specified letter? (in this case / )
I'm using SQL server 2008 express.