Scenario
You followed our instructions in our document about locating ‘Select’ statements but how can be sure you found every single statement? What if some users created these statements in UPPER case and some used sentence case or even lower case? Databases are case sensitive so if this is the case your resulting table will only show some of the results.
Solution
We could make a quick change to our ‘Column Select’ object in the Data Connection that will convert everything to a particular case and therefore make it easier for us to ensure we’re finding every instance of a ‘Select’ statement.
...