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

showing results for - "reading from right to left from string find first special characters in sql"

1DECLARE @strvalue varchar(20) = 'SDADH/SDKDS/SD/UIO-123/WEA/456'
2SELECT REVERSE(SUBSTRING(REVERSE(@strvalue),0,CHARINDEX ('/',REVERSE(@strvalue))))

similar questions

split first name and last name in sql sql find leading space sql first character how to fetch first 5 characters in sql get first name and last name from full name string in sql display first three characters sql sql remove first character from string fetcht he leftmost word in a comma separated string in sql sql left characters sql print all names that start with a given letter characters found after end of sql statement get first 3 letters in sql get first 3 letters name in sql sql right characters t sql return on letters only starts and end with vowel sql sql where part of string match sql remove characters from string right match end of string regex sql sql character index get first 2 letter in sql get first 3 letter of department name in sql get first n letter of department name in sql reutrn string after character sql oracle leftmost characters

queries leading to this page

substring from right end of string in sql select left sql sql get first character of string how to get first three characters from a string in sql left sql server sql query sql query find location of string right to left sql right 7 characters sql first 10 characters of field reading from right to left from string find first special characters in sql retrieve right 4 digits in sql last charter in string sql sql first four characters return the right char in sql reading from right to left from string find first special characters in sql