We are currently using an inputlookup command to populate a list based on some wild card searches using input tokens from a KV store lookup with customer details like below     | inputlookup $site$-patrondetails WHERE FirstName=$firstname|s$ patron = $patron_id|s$ LastName = $patron_surname|s$ ResAddr = $patron_address|s$ MobilePhone = $patron_mobile|s$     where the token values are based on the value the user types into an input text box and the site token is a drop down value.   until recently we havinputlookup e had 2 sites where all the data in the source system is stored in uppercase but we have recently onboarded a 3rd site where the data is stored in both upper and lower case values.  as it turns out the where clause in is case sensitive.  I have tried adding case_sensitive_match = false to the transform.conf stanza for this patrondetails lookup definition but this has not seemed to have any effect on the results being returned from the search. Have I missed something with this config or is there something else I need to add Any help would be appreciated, Tom ... View more