Category: T-SQL
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 […]