Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql substring before last occurrence of character

SELECT LEFT(assocname, LEN(assocname) - CHARINDEX('>',REVERSE(assocname)))
Source by dba.stackexchange.com #
 
PREVIOUS NEXT
Tagged: #sql #substring #occurrence #character
ADD COMMENT
Topic
Name
7+8 =