I have a simple select * query that loads a table consisting of about 20 fields. 10 of these fields are long text fields. Upon loading the data, I need to search all 10 of these fields to see if the string "requested" exists in any of these fields. How many matches it finds doesn't matter, just a true or false is needed if at least one match is found. So I'm thinking I'd be able to do this with a proceeding load where I create a new field called "request status" that holds either "true" or "false". What is the best way to do this without a bunch of nested If statements using substringcount?
