Get Substring by text in SQL

In Microsoft SQL, the SUBSTRING allows you extract part of a string using a start index and length. For example: SELECT SUBSTRING(‘hello world’, 2, 3)   Results in an output of ‘ell’. However, there is no ability to select the start and end of the sub-string using known letters or words. The SQL example shown below […]

Read More…