Software (include version): DocStar 

Use Case: Using a Type ahead or an instance of needing to query a csv or other data source where the values are all CAPS, and search not using all caps results in no result. This is referencing the data source of a csv in this instance where you cannot use UPPER variable in query


  • JOE SMITH works

  • Joe Smith does not work

  • joe smith does not work

Customer: N/A

Prerequisites: N/A


  • Use the LCASE function in your statement - see example

    SELECT * FROM CustomerFile.csv WHERE LCASE(customername) like LCASE('%' + @CustomerName + '%')