SQL tip: Use CHARINDEX with LEFT to dynamically strip text from the end of a string CHARINDEX(‘look for this’, [fieldName1]) LEFT([fieldName1], #) LEFT([fieldName1], CHARINDEX(‘look for this’, [fieldName1])) #ssms #sqltips #dataanalytics #dataanalyst #d… https://t.co/Xga5EGowA5

SQL tip: Use CHARINDEX with LEFT to dynamically strip text from the end of a string

CHARINDEX('look for this', [fieldName1])
LEFT([fieldName1], #) LEFT([fieldName1], CHARINDEX('look for this', [fieldName1])) #ssms #sqltips #dataanalytics #dataanalyst #d… https://t.co/Xga5EGowA5

— noobtastic_com (@ron_mills) November 14, 2019

from Twitter https://twitter.com/ron_mills