I am using Data Studio to write a query for a DB2 AIX database. I have a small issue I'm running into.
I have a column that appears like this:
I need to extract all characters, starting from the "SBN", all the way up to, but not including, the equal sign. The numbers after "SBN" can be of varying length, so I just need the beginning of the string up until the equal sign. What is the easiest way to accomplish this?