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
No responses yet