SUBSTRING and CHARINDEX functions are two of the most commonly used string functions in SQL. They allow you to extract and search for substrings within strings. SUBSTRING: The SUBSTRING function is ...

Learn how to use MID() and FIND() and then combine them to parse substrings from inconsistent data. Parsing data is a common task in Excel. For the most part, you’ll do so when you need to work with ...

Sandra is a Tech enthusiast with a Journalism and Full-stack web development background. She specializes in web development and Cloud technology. For leisure, Sandra enjoys a good thriller, hugging ...

Blog post: Using Case Expressions and Substring Function in Select Statements - A Short Guide for ABAP and ABAP on HANA Developers. Within newer versions of Open SQL, you can now add both simple and ...