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 #dataanalysis #coding #codinglife #programming #datascience #backend #bigdata #database #sql #sqlserver #sqldeveloper #azure #azuresql #sqlazure #microsoftazure #worldcode #thedevlife #backenddeveloper #fullstackdeveloper #fullstack #fullstackdev