How do I get part of a string with SQL? (part 2)

Remember when we previously talked about extracting part of a string with SQL? As SQL Server and PostgreSQL would not support a "mid" function, getting a string that was placed in the middle of another could be a bit tricky.... We then solved it by applying a double right() and left() functions. There is, however, another …