reading from right to left from string find first special characters in sql

Solutions on MaxInterview for reading from right to left from string find first special characters in sql by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
showing results for - "reading from right to left from string find first special characters in sql"
Kim
26 Aug 2019
1DECLARE @strvalue varchar(20) = 'SDADH/SDKDS/SD/UIO-123/WEA/456'
2SELECT REVERSE(SUBSTRING(REVERSE(@strvalue),0,CHARINDEX ('/',REVERSE(@strvalue))))